Solved

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

Posted on 2011-09-15
3
366 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:Steve_Brady
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 4

Expert Comment

by:maxsmith5k
ID: 36547471
0
 
LVL 4

Expert Comment

by:maxsmith5k
ID: 36547479
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
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 36547530
Hello Steve,

when you set up your merge document as an Email Merge, using the Wizard, or manually, you will reach a point where you complete the merge. If you use the Wizard, there will be a command in the side panel. If you go the manual route, click Finish and Merge on the Mailings ribbon.

You will be presented with a dialog like this
 dialog
This is where the email address comes into play.

In the first dropdown, select the field from your data source that holds the email addresses you want to use.
In the next field enter the email subject.

Hit OK to complete the merge

cheers, teylyn
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question