More than one snapshot per email


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

Advertisements

R

Rick Brandt

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

Advertisements

E

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top