rickvandelaar
asked on
using Word 2007 mail merge to send bulk e-mail
Hi,
Here is what I wish to achieve:
I want to automate sending a large number of mails using Word 2007.
First I have the Word 2007 document that contains the basic invitation message.
The invitation message has to be populated with data from a excel sheet containing the columns First name | Last name | Application name.
Next, I would like to bulk send the mail to each of the users containing the application name I'd like them to test for me:
What would be the best way to do this?
Here is what I wish to achieve:
I want to automate sending a large number of mails using Word 2007.
First I have the Word 2007 document that contains the basic invitation message.
The invitation message has to be populated with data from a excel sheet containing the columns First name | Last name | Application name.
Next, I would like to bulk send the mail to each of the users containing the application name I'd like them to test for me:
Hi [[first name]] [[Last name]],
I would like to schedule a appointment to test [[Application name]].
What would be the best way to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Graham...you mean like in the MS article I posted?
Solution provided for question asked.
There is a 'Wizard' to take you through each step: Mailings tab, Start Mail Merge dropdown, Step by Step Mail Merge Wizard... item.