More than one snapshot per email

[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.

 

[Rick Brandt]

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.

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.

 

[Eric D. Braden]

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.

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