2 rapport's as attachment in one e-mail

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

Guest

Can somebody tell me if it's possible to send two rapport's from the same
database in one e-mail as attachment? I am using microsoft access 97.

Thank you in advance!!!!
 
Access's native SendObject doesn't support this.
If it's important that the reports be sent as separate files, you'd have to
use Automation, or CDO, or some such.

However, a simple solution may be to embed both reports as subreports in
another report (which doesn't need to include anything else).

HTH
 
Thank you MacDermott!
Can you tell me please (!) how to do that by using Automation, or CDO, or
some such? I would sincerely appreciate it!
Also, is it possible to adjust e-mail subject from a field in one query?

THANK YOU VERY MUCH!
 
I'm afraid explaining Automation and/or CDO is a bit much for a newsgroup
post, but if you'll Google around (add MSAccess or VB to your search to
narrow it down to the right syntax), I'm sure you'll find some code.

And yes, you can read data from a query field and put it in the "to" line.
You can string a bunch of addresses together with semicolons, and send them
out as one e-mail, or you can send each e-mail separately.
 
Back
Top