email Email merge to different recipients

[Cpreston]

Hi

Does anyone know of anyway to send an email to many recipients that are listed in an excel column. We want to send the email invidually to the people listed in the column rather than to all at once, so people do not see other peoples email addreses.

Any ideas please

Thanks

 

[SkipVought]

hi,

Check out this FAQ.

faq68-4223

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[macropod]

Does anyone know of anyway to send an email to many recipients that are listed in an excel column. We want to send the email invidually to the people listed in the column rather than to all at once, so people do not see other peoples email addreses.

That's essentially how and email mailmerge from Word works. No code required. See:

https://support.office.com/en-us/ar...or-email-0F123521-20CE-4AA8-8B62-AC211DEDEFA4

https://support.office.com/en-gb/ar...ess-list-6ac6b411-ac8d-48b3-8bcb-588b460c18ff

Cheers
Paul Edstein
[MS MVP - Word]

 

[Cpreston]

Hi

Thanks for the reply's.

Sorry Skip I took a look at the link and don't understand how it works at all.

I have 2 spread sheets one a price list and in the other a list of all names and email addresses.

We want to send the price list to all the 200+ email recipients but all separately. The wording in the email is to be the same for each recipient.
I could add a tab in the price list for the email addresses if this would make it easier.

Is it possible you could explain in idiots guide please. Thanks


Macropad thanks for the reply but cannot relate it to this as we have spreadsheets involved but thanks for the advice

 

[Cpreston]

Hi

MAcropad you solution using Word 2010 email merge would work, however it does not allow you to add attachments. Is there a way in the process in Word 2010 to add an attachment. I have tried it several times, it send emails great but as no option anywhere to add attachment to the email.

Thansk

 

[macropod]

cannot relate it to this as we have spreadsheets involved but thanks for the advice

Which is precisely what a mailmerge is for. Did you even look at the links I posted?

Cheers
Paul Edstein
[MS MVP - Word]

 

[Cpreston]

hi

Yes I did just (in more depth afterwards so apologies) replied its the attachment side is the issue , cant figure out how to do that

Thanks

 

[macropod]

You have two options for the price list:
1. Include the price list in the body of the email;
2. Use a macro to drive the mailmerge. See:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Cheers
Paul Edstein
[MS MVP - Word]

 

[Cpreston]

Hi


Thanks, I managed to get it working with this link in the end. Although not related to 2010 as such it worked for me. Thanks for the replys

https://www.bangor.ac.uk/itservices/office365/help/MailMergeIncAttachment.html

 

[JVFriederick]

CPreston

You recently said you got it working, using a third party app?

If you are interested in another solution, attached XL file should work for you.
It requires the email address and salutation for each email, and can also send multiple attachments.

I have used this file and VB code many times to send emails directly from Excel.