Mail Merge with Multiple Attachments

[kevinsamuelabraham]

Hi All,

I know how to create a mail merge from word document with custom fields incorporated throughout the body of the email. The method I follow is described in the link:

http://www.baylor.edu/content/services/document.php/48542.pdf

I need to make additions to have one more attachments with each of the emails. Research has pointed to this page: Merging With Attachments

Unfortunately, I don't think I am following the instructions correctly, since I am unable to follow some of the language in there.

1) I have created a word document with a 3 column table, column 1 is the email address, column 2, and column 3 path to the file names.
2) I run the code, it asks me to select the file which I do and enter the subject line
3) After which it tells me zero emails were sent

Not sure what I am missing and how to send a mail merge with multiple attachments along with a customized body.

Any help would be much much appreciated.

Best,
Kevin.

Also, I looked at this previous thread: http://www.mrexcel.com/forum/excel-...il-attachments-visual-basic-applications.html

but it looks like that one had a standard body..

 

[kevinsamuelabraham]

Clarification: By customized body I mean the following

------------------------------------------------------
Dear xxxxx,

To reward your exemplary service, you are going to be awarded $xx,xxxx as an appreciation from your Manager xxxxxxxx.

Attached document contains the details.

Best,
xxxxxxxx

-------------------------------------------------------
The xxxxx are replaced through mail merge. The data is pulled from an excel file

 

[kevinsamuelabraham]

Gentle bounce

 

[kevinsamuelabraham]

Help .. PLzzz