Email multiple reports

  • Thread starter Thread starter Guest
  • Start date Start date
BB,

If you are trying to use a SendObject macro or method, then I think the
answer is No, not directly. You can use OutputTo to save all reports
except the last one to file, and then use SendObject with the last of
the reports, with the Edit Message argument set to Yes/True, and when
the email message opens in your email client, you can manually add the
earlier report files as attachments before sending the email.

Another approach is to use Office Automation to create an Outlook email
and use code to add the report file attachments. You will find some
information on this via http://www.granite.ab.ca/access/email.htm
 
Back
Top