Mail Merge with Attachments

sagarph

New Member
Joined
Jun 11, 2013
Messages
2
Dear Mr. Excel,

First of all I wish to thank you for uploading loads of interesting videos on Youtube which certainly help a lot, absolutely generous of you :)

I hope the following will not be much of an issue for you and you would be able to help me at the earliest

I am trying to create a mail merge, I have the mail drafted in word, I have the database in Excel, now I need to attach a file with each mail that goes out

I face following problems doing this

1 - I don't know how to attach files using mail merge
2 - How can I attach a different file for each mail merge (I mean, based on the recipient, the attachment will be different)

Though this is not very important, but is it possible to have a reference number in the subject line with each mail (the reference number will be different for all recipients)

Would appreciate your assistance on this

Regards
Prakash Sagar
sagarph@gmail.com
 
Last edited:

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,216,552
Messages
6,131,320
Members
449,644
Latest member
tbhoola

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top