I'm trying to create an email mail merge that will personalize the emails to each individual on my list, at the same time attach a document.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I can currently do everything with a simple mail merge aside from the file attachment. I've read that a VBA macro can accomplish this but my VBA skills are very limited (editing code is semi tough without an example).<o></o>
<o></o>
I have the Word document created for the email with a space for the merge to personalize to the individual based on Column A.<o></o>
<o></o>
Column A - Preferred Name (the name used at the heading of my Word document for personalization)<o></o>
Column B - Email Address<o></o>
Column C - Attachment (the File path to the document)<o></o>
<o></o>
Any help with the VBA coding and the process from where I'm at to successfully sending an attachment with the Word document would be a big help.<o></o>
<o></o>
Also need to add a Subject line to the email so not sure how that works once the VBA is set.<o></o>
<o></o>
Thank you for any help.<o></o>
<o></o>
I can currently do everything with a simple mail merge aside from the file attachment. I've read that a VBA macro can accomplish this but my VBA skills are very limited (editing code is semi tough without an example).<o></o>
<o></o>
I have the Word document created for the email with a space for the merge to personalize to the individual based on Column A.<o></o>
<o></o>
Column A - Preferred Name (the name used at the heading of my Word document for personalization)<o></o>
Column B - Email Address<o></o>
Column C - Attachment (the File path to the document)<o></o>
<o></o>
Any help with the VBA coding and the process from where I'm at to successfully sending an attachment with the Word document would be a big help.<o></o>
<o></o>
Also need to add a Subject line to the email so not sure how that works once the VBA is set.<o></o>
<o></o>
Thank you for any help.<o></o>