Create a button that opens Outlook and attaches a file to email

[JS]

I created a button that launches Outlook using SendObject. I have all the
appropriate fields filled in however I need to attach a Survey that resides
in Microsoft Word and is not part of my database. Is it possible to do that?
I keep the form located in the same folder as my database. Any suggestions
are appreciated!

 

[Steve Schapel]

JS,

No, this is not possible with a macro. Well, not unless you set the
Edit Message argument of the SendObject action to Yes, and then manually
attach the Word document to the email before sending. Otherwise, you
would need a VBA procedure using Office Automation to do this. There is
some good information on this here:
http://www.granite.ab.ca/access/email.htm

Another option would be a third-party emailing utility, for example
Total Access Emailer available from www.fmsinc.com

 

[JS]

I will visit the website. Thank you Steve for your input.