E-mailing reports

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

Guest

I'm trying to e mail 2 reports from access 97 but find the following.

1. I can't send both reports in one e mail.
2. One of the reports has several pages and for each page of that report I
get an attachment instead of one attachment showing all pages.

Any ideas???
 
MyMate,

I assume you are trying to use a SendObject macro or method to send the
email? You can't directly add more than one attached report using this
approach. There are a few options to consider...
1. Make a blank unbound report, and add both of your existing reports
as subreports, with a page break between them, and send this.
2. Use an OutputTo for the first report, to save it to file, then
SendObject for the second, with the Edit Message argument set to
True/Yes, and then when the email opens in your email client, with the
second report attached already, manually attach the first one before
sending.
3. Use Office Automation code to construct an Outlook email with your
report files attached. Further information about this can be fouind via
http://www.granite.ab.ca/access/email.htm

As for the question of a separate file for each page of the report, I
guess this means you are using HTML format for the report output. As
far as I know, there is no way around this.
 
Back
Top