Hi All,
Can anyone help, With the help of this forum I have completed a certain task – but the’ icing on the cake’ would be my last query.
Does anyone know a way where I when I convert my access database to excel , I can place the excel data into a excel template as a separate worksheet.
Basically I have an access database which shows ‘open/overdue orders’ with our suppliers which we will send out via email. My current macro converts that data to excel as a lotus notes attachment , but you only have a ‘limited no of characters ‘ within the ‘message text’ field in the macro.
My excel template I wish to add the converted access data has a covering worksheet with company logo, contact details & a standard message & I would like the actual data to go as a worksheet within the excel spreadsheet(a page 2 if you like), or if easier, all on the 1 worksheet but below the company logo & standard message.
Any help, much appreciated
Can anyone help, With the help of this forum I have completed a certain task – but the’ icing on the cake’ would be my last query.
Does anyone know a way where I when I convert my access database to excel , I can place the excel data into a excel template as a separate worksheet.
Basically I have an access database which shows ‘open/overdue orders’ with our suppliers which we will send out via email. My current macro converts that data to excel as a lotus notes attachment , but you only have a ‘limited no of characters ‘ within the ‘message text’ field in the macro.
My excel template I wish to add the converted access data has a covering worksheet with company logo, contact details & a standard message & I would like the actual data to go as a worksheet within the excel spreadsheet(a page 2 if you like), or if easier, all on the 1 worksheet but below the company logo & standard message.
Any help, much appreciated