 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / May 2005Sending multiple reports by email
Hi everyone, I know you can use the SendObject method to send a single item via email (I'll be using the Snapshot format) but I really want to send more than one attachment. Is there a way to do this? Is it possible to 'fool' Access into thinking there's only one attachment when there are a number?!! Do you know of any code that I could use as I'm not too clever with VB? Any help or advice would be really appreciated! Regards, Lee There are a number of places to look. Try one of these. MSDN article on creating appointments, emails, etc., using Automation http://tinyurl.com/2knwj Q161088 Using Automation to Send a Microsoft Outlook Message http://support.microsoft.com/?id=161088 HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000 http://support.microsoft.com/?id=209948 ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients http://support.microsoft.com/?id=318881 Also, have a look at Tony Toews' email page: http://www.granite.ab.ca/access/email.htm Chris >-----Original Message----- >Hi everyone, [quoted text clipped - 9 lines] >Lee >. The links are really helpful. Thanks very much!!! Lee > There are a number of places to look. Try one of these. > MSDN article on creating appointments, emails, etc., using [quoted text clipped - 34 lines] > >Lee > >. You might want to look into a third party email component like aspmail www.serverobjects.com and just use the one dll next to your database instead of automating through Outlook. Just my opinion, Mark RPT Software http://www.rptsoftware.com We have an example in our eval of the batch reporting module product that creates a bunch of pdf files and then creates a bunch of emails, some emails have multiple attachments. However I used aspmail to simplify my life in the example. > Hi everyone, > [quoted text clipped - 7 lines] > > Lee i see how the create mail works but how do I call the function to actually send the email? Looks like I also have to set up and array of attachements. Would these be send objects or just the report names. thanks lori > Hi everyone, > [quoted text clipped - 7 lines] > > Lee You can use out code to: - Create as many reports as needed - Create emails (with as many attachments) and send them I would use PDF format instead of SNP and our examples just use a third party email component called ASPMail. See the batch reporting module product on our website. Our source code just goes right into your MDB file. ASPMail is one DLL you need in the same directory. HTH, Mark RPT Software http://www.rptsoftware.com > i see how the create mail works but how do I call the function to actually > send the email? [quoted text clipped - 17 lines] > > > > Lee |
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.