 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / November 2004E-mail Excel worksheet from within Access
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 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 >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 [quoted text clipped - 6 lines] > >Mark -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. John Thanks a lot for the guidance Cheers Mark > Hi Mark, > [quoted text clipped - 28 lines] > > Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.