Emailng Reports

[Guest]

I'm trying to e mail (outlook express) 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

 

[SA]

FourChar:

1.) With Access' built in capabilities, there is no way to combine multiple
attachments (i.e. reports) into a single e-mail.

2.) Are you exporting using a Snapshot format or some other format? It
sounds as if you are exporting to HTML. If this is the case then yes,
you'll get one file for each page. You can either a.) export to RTF to get
a single file, or b.) Export to a snapshot file (specify "Snapshot Format
(*.snp)" in the export format option, or c.) Print the report to a PDF file
and attach that to your email.

If you are interested in using PDF files and attaching multiple reports to a
single file, then you might want to check out our PDF and Mail Library for
Access, which supports numerous (often inexpensive) PDF drivers that you
could use to automate output of your reports to a PDF file.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"fourchar(removethis)@bigpond.net.au"

 

[Guest]

You are correct with the HTML but when I tried RTF the format of the output
file (an invoice being issued) was all messed up and I was still left with
two e mails, one for the invoice and one for the invoice details.

Can your pdf file cope with maintaining the format and combining both access
reports (the invoice and the invoice details) in the one e mail??

Many thanks your help

 

[SA]

The answer is yes on both fronts.


--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"fourchar(removethis)@bigpond.net.au"