Sending multiple reports by email

[Guest]

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

 

[Chris Reveille]

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

 

[Guest]

The links are really helpful. Thanks very much!!!

Lee

 

[Mark Andrews]

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.

 

[Guest]

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

 

[Mark Andrews]

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