Automated Email from Access

[dboddington]

Hi

I am trying to automate an email process from Access. In a query I have fields such as firstname, lastname etc and an email address and a path to a spreadsheet to be added as an attachment.
I want to be able to click a button on a form (for example) and then send a personalised email (including merge fields in the body of the email) with the specified attachment. The email client will be Outlook.

I have tried (successfully) using Word to merge into - but I believe you cannot add attachments through Word automation (could be wrong here). So any pointers about using Outlook automation?

 

[RichD]

Take a look at Mike Thornton's excellent faq705-1634 in the FAQ section of this forum. I have just used it - no problems at all.

Rich

Bespoke and off-the-shelf Access solutions

http://www.blsoftware.co.uk

 

[dboddington]

Many many thanks for directing me to this. It does exactly what I want.