Solved

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

Posted on 2011-09-15
3
357 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
  • 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 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
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 Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

816 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now