More than one snapshot per email

  • Thread starter Thread starter Eric D. Braden
  • Start date Start date
E

Eric D. Braden

Anyone able to steer me towards attaching more than one report to an
email in Access 97 (using a macro)?

I'm trying to streamline our process here, which currently involves
printing two reports, then scanning them into an imaging database,
then emailing that scanned file to its recipient. Instead of that, I
want to just have it automatically attach it to an email (like with
SendObject), but I don't know how to automate that with just one email
instead of two.
 
Eric said:
Anyone able to steer me towards attaching more than one report to an
email in Access 97 (using a macro)?

I'm trying to streamline our process here, which currently involves
printing two reports, then scanning them into an imaging database,
then emailing that scanned file to its recipient. Instead of that, I
want to just have it automatically attach it to an email (like with
SendObject), but I don't know how to automate that with just one email
instead of two.
Click to expand...

Only one attachment per message with SendObject.

You might be able to embed both reports as sub-reports inside of a container
report and then just attach that as one combined file.

Otherwise you can drop SendObject and instead automate an external messaging
library like Outlook or CDO. Then you can have as many attachments as you
want.
 
Only one attachment per message with SendObject.

You might be able to embed both reports as sub-reports inside of a container
report and then just attach that as one combined file.

Otherwise you can drop SendObject and instead automate an external messaging
library like Outlook or CDO. Then you can have as many attachments as you
want.
Click to expand...

Thanks very much! I think I'll just go with outputting it and
automate the attachment outside of Access, like in your second
suggestion.
 
Back
Top