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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top