mulitple attachments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to send an email through access that has multiple
attachments? I have been using the send object method, but now need to send
multiple reports from the database to a single user.

Matthew
 
Matthew,

There are a number of possible approaches to this, depending on your
circumstances...

1. Make a blank unbound report, and add all your existing reports as
subreports, separated by pagebreaks. This can result in a single file
getting emailed, but in practice the end result when printed is no
different from the set of individual reports.

2. Use OutputTo instead of SendObject for all reports except the last
one, so that they are saved to a suitable local folder. Use SendObject
for the last report, with its Edit Message argument set to True/Yes, and
when the email opens in your email client, manually attach the other
files before sending.

3. Use Office automation in a VBA procedure to construct the email
messaage and add the required attachments. You will find some good
information about this approach at
http://www.granite.ab.ca/access/email/outlook.htm and
http://support.microsoft.com/?kbid=161088
 
Back
Top