Link to home
Start Free TrialLog in
Avatar of rickvandelaar
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:

Hi [[first name]] [[Last name]],

I would like to schedule a appointment to test [[Application name]].

Open in new window


What would be the best way to do this?
ASKER CERTIFIED SOLUTION
Avatar of Scott C
Scott C
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Word's mail merge is built for that job, but you would need the Excel sheet to contain each eMail address in one of the columns.
There is a 'Wizard' to take you through each step: Mailings tab, Start Mail Merge dropdown, Step by Step Mail Merge Wizard... item.
@Graham...you mean like in the MS article I posted?
Solution provided for question asked.