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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.