Multiple Reports in email

[Madmax]

Afternoon,
I have 3 reports that have to go out to my section heads each week. I currently had the ability to do it on one report. Is there a way to export all three reports and send them in the same email? Kind of anoyed with the constant send send of emails. if there isnt a quick way then I will probable just combine the emails.

In all honesty I would love to have the ability to export them to excell as different sheets and have the whole file send to various email addresses. if you have an example please use the following varibles so I know where to edit it at.

Report 1, Report 2, Report 3----- yes they have spaces in the names

Email_1@B.A.M;Email_2@B.A.M

Subject: Shop Listing



Message: "Automated Email of Database"

Thank you for your help.

-madmax(not so mad )

[pbaldy]

You can't use SendObject to send more than one. You can use automation:

http://support.microsoft.com/?kbid=209948

I think you can also use CDO.

[Madmax]

on the automation. I kind of understand it but what would be the path or would you have to have a macro setup to export the items first and then email them by putting in the run command?

[pbaldy]

You have to create the file first with this method (or probably any other method that allows multiple attachments).