Access E-mail Attachments

[Spring Hill TN]

Is it possible to code in Visual Basic to attach more than one Access report
in .snp format to a single e-mail? Anotherwords, I have several Access
reports in the same database that I want the user to be able to attach to one
e-mail as a one step function.

 

[Arvin Meyer [MVP]]

Yes. If you're using Outlook, here's the code:

http://www.datastrat.com/Code/OutlookEmail.txt

 

[Mark Andrews]

You can also do it with a third party smtp component.
My demo does this:
http://www.rptsoftware.com/products/email/

I would use pdf format over snp.

HTH,
Mark

 

[Tony Toews [MVP]]

Is it possible to code in Visual Basic to attach more than one Access report
in .snp format to a single e-mail? Anotherwords, I have several Access
reports in the same database that I want the user to be able to attach to one
e-mail as a one step function.

Yes, but not using SendObject as that's one of it's many limitations.

For alternatives see Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony

 

[Spring Hill TN]

Thank you for your response ... it worked perfectly!