dboddington
Instructor
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?
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?