Steve_Brady
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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i think that this is what you need:
http://office.microsoft.com/en-us/excel-help/print-labels-by-using-excel-data-in-a-word-mail-merge-HP005203760.aspx