SendObject HOW CAN I SEND TWO REPORTS IN THE SAME MAIL WITH

[Guest]

SendObject : HOW CAN I SEND TWO REPORTS IN THE SAME MAIL WITH SENDOBJECT
COMMAND IN ACCESS 2000

 

[Steve Schapel]

PAFI,

You can't do this directly with a macro. The closest you can get, I
think, would be to use an OutputTo action for the first report, which
will save the report to a file on disk, then a SendObject action for the
second report, with the Edit Message argument set to Yes. This will
open the message in your email client, with the 2nd report already
attached, and then you will need to manually attach the first report to
the email before sending.

Otherwise, you will need to use a VBA procedure. On this subject, there
is some good information here...
http://www.granite.ab.ca/access/email.htm