Attaching a file when emailing from Access / Word

[genie]

I want to email contacts held in an access database using Mail Merge
but also want to add another attachment ( ie a .pdf). I can mail merge
in Word using the access source no problem but how do I add another
attachment
to email ?

Or can I do this from Access itself ? I know I can email a report
easily but how do I add an attachment as well ?

 

[Chris_E]

I want to email contacts held in an access database using Mail Merge
but also want to add another attachment ( ie a .pdf). I can mail merge
in Word using the access source no problem but how do I add another
attachment
to email ?

Or can I do this from Access itself ? I know I can email a report
easily but how do I add an attachment as well ?

You can indeed send email from your Access database and include an
attachment as well.To do this you need some VBA coding that works with
your email application (I'm assuming Outlook here).

A quick Google found this page:

http://www.blueclaw-db.com/access_email_send_outlook.htm

Good luck!!

Chris