Send E-Mail With Non-Access Attachment

[Chris]

I have been able to successfully send e-mail via Access and the SendObject
command, but I see that the objects which I can attach are only of the
Access variety. How can I use the SendObject command to attach an unrelated
file, e.g., an Excel spreadsheet or Word document from My Documents?

 

[Rick Brandt]

I have been able to successfully send e-mail via Access and the SendObject
command, but I see that the objects which I can attach are only of the
Access variety. How can I use the SendObject command to attach an unrelated
file, e.g., an Excel spreadsheet or Word document from My Documents?

You can't. For that you would need to automate a third party Email program
or library like Outlook or CDO. See link below for example of that.

http://www.mvps.org/access/modules/mdl0019.htm

 

[Peter De Baets]

Chris,

This link should help: http://www.peterssoftware.com/c_emfa.htm

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com