Link to home
Start Free TrialLog in
Avatar of Steve_Brady
Steve_BradyFlag for United States of America

asked on

Mail merge -- Word and Outlook with Excel data source: how do you insert the e-mail addresses

Hello,

I have got an Excel spreadsheet data source with the following four headings in A1:D1:

            First            Last            Email1            Email2

First is the first name.
Last is the last name.
Email1 is the simple email address:  johndoe@abc.com.
Email2 is the display as form:  John Doe (johndoe@abc.com).

The workbook has been named and saved to a folder.

I have written the mail merge document in MS Word and gone through all the steps to insert the fields.  The only thing I can remember is how/where to insert or designate the email addresses (using column C, Email1).

Thanks
Avatar of maxsmith5k
maxsmith5k
Flag of Sweden image

if you are using 2010 then this could help instead:

http://www.addictivetips.com/microsoft-office/word-2010-mail-merge/

Please let me know if you are using something other than 2003 or 2010
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand 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