E-Mail Multiple Reports

[Guest]

I know that SendObject will only allow you to attach one file to an e-mail.
I need a creative solution to attach multiple reports to one E-Mail message.
I have a Access 2003 application that will automatically generate 2 to 3
reports for a users query. Those reports need to be e-mailed to a customer
and we do not want to seperate them into multiple e-mails.
Printing or Exporting to a file then sending that file is acceptable but I
can not find the ability to append in either case, I only get the option to
overwrite.
Thank you in advance for your help.

 

[Guest]

You are right about "SendObject" Only one attachment there. You can check
out OUTLOOKCODE.COM which is a forum/website that may help you find a way to
get three attachments, you may need a third party software. There is the
option of printing one report to an RTF file and then placing that as a word
document in the message body and then attach another report, but that won't
help if there are three reports and it will involve alot of code. There is a
lot of info about using Outlook at that site, they may have a solution

 

[Guest]

Thanks for the info, I'll take a look at that forum. In the mean time, is
there a way to print the three reports to a single file, appending each as it
prints? Then I could use SendObject the send that file the the customer.
Thanks for the help.

 

[Guest]

I only am aware of that in third party software, sorry I am not that much help