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-com
ffice
ffice" /><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


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


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


Column A - Preferred Name (the name used at the heading of my Word document for personalization)<o


Column B - Email Address<o


Column C - Attachment (the File path to the document)<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


Also need to add a Subject line to the email so not sure how that works once the VBA is set.<o


<o


Thank you for any help.<o

