send mutiple report in one email

[Guest]

Hi,

I just want to know if it is possible to send multiple report in a single
email with out the saving on to the computer first and insert the attachment.

Currently I have 3 reports button that I pressed and each will open up the
email with the snapshot attached. What I want to do is combine the three into
one email and reduce the need to pres 3 buttons 3 time.

Is there coding involve in automating the process

Any suggestion is greatly appreciated.

Jai

 

[Tony Toews]

I just want to know if it is possible to send multiple report in a single
email with out the saving on to the computer first and insert the attachment.

Currently I have 3 reports button that I pressed and each will open up the
email with the snapshot attached. What I want to do is combine the three into
one email and reduce the need to pres 3 buttons 3 time.

Is there coding involve in automating the process

Yes, you will have to use an approach other than SendObject.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Thanks Tony

I thought on the same line about writing the code but due to my limited
skill i feel that i would not be able to do it.

So the file sample on your web site would enable me to do what I want right?

Jai