E-mail Excel worksheet from within Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am setting up an automated way of e-mailing reports to certain individuals
at differing times. I am quite comfortable sending reports from within
Access itself, my problem is that I have a report that is a worksheet in
Excel. Currently I am saving the selected area within that worksheet as an
html page and sending it separately. Is there a way that I can include it
within the automated process.

TIA

Mark
 
John
Thanks a lot for the guidance

Cheers

Mark
John Nurick said:
Hi Mark,

Yes, you can use VBA code running in Access to launch Excel and
manipulate the workbook. These links should get you started:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476


http://support.microsoft.com/?id=253235
Click to expand...
 
Back
Top