How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 16838
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

How can I run an e-mail mail merge using Outlook and/or Word

Resolved Question:

How can I run an e-mail mail merge using Outlook and/or Word 2007 that allows me to put in multiple addresses in the To field (e.g, several contacts from a particular client), multiple addresses in the cc: field (all of my in-house people who are connected with that client, and another address in the bcc: fiield?

I've got a data sheet ready (with appropriate addresses separated by semi-colons in the To: XXXXX XXXXX: fields for each record) - but don't see how to connect that to an e-mail merge.

Can it be done within native Outlook/Word? Or is there an add-in you could recommend? Thank you!
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Richard replied 2 years ago.

RichieMe :

Hi there and welcome

RichieMe :

To do this

RichieMe :

Select the tab Mailings-> click the Start Mail Merge button-> Step by Step Mail Merge Wizard…

RichieMe :

in word

RichieMe :

The Task Pane panel will open on the right side of the document to choose the document type.
Here select “E-mail messages”.

RichieMe :

Press Next


"Select from Outlook contacts".



As you can have multiple Contacts folders in Outlook you need to select the actual folder which we will be using by pressing "Choose Contacts Folder".



 

RichieMe :

After selecting the Contact folder of your choice you could be presented with the "Choose Profile" dialog from Outlook. If you don’t know this dialog there is probably one selection in the drop down list anyway or set to the correct default so simply press OK.


Word now opens the "Mail Merge Recipients" dialog where you can specify which contacts to send to.
While the dialog in Word 2007 has been improved to allow for more selecting and filtering options than in previous versions of Word, personally I think it’s still a bit clunky and can be slow when you have a lot of contacts as it also refreshes the screen after pretty much every action. However, the "Find duplicates…" feature is quite handy especially when you want to use the entire Contacts folder for your mail merge.



 

RichieMe :

After selecting the recipients, the next step is to write your message. The Mail Merge Wizard already shows you some variables you can use.


The next step allows you to preview all the emails you’ll eventually be sending.


You can press "Electronic Mail…" to set the final options before mailing your message

To: Email_Address
Subject line: Your personal information



After setting the options, pressing OK will direct start sending the emails.



 

RichieMe :

Let me know please if you have any difficulties

Customer:

I don't think you've read my question carefully. I'm trying to do something beyond an ordinary merge 1-address-at-a-time merge - specifically, for EACH message I am going to send, I need to be able to assign several addresses to the To field, several addresses to the cc: field, and one address to the bcc: field. Is there a way to control this in Office? Or is there perhaps an add-in that you would recommend?

Customer:

I have to leave, but will be interested in your reply. Many thanks!

RichieMe :

ok, what you are going to need to do is export your contacts from outlook to a CSV file

RichieMe :

You then open this CSV in Excel and put all the email addresses into the primary email seperated by a ;

RichieMe :

this way all the email addresses are in one cell

RichieMe :

you then make a new address box in Outlook and import the CSV file into it

RichieMe :

and perform the merge from this

RichieMe :

Let me know if you have any difficulties please

Customer:

Ok - I get that this is not the best forum for this involved a question. And I now understand that you're not getting paid much for the exchange. But I'd like to try one last time, since I did pay $39 for this, and if there's really something useful in your response, I'd very much like to get it. Exporting to csv I get. But are you suggesting I essentially put all the addresses in the To: XXXXX XXXXX send a signle e-mail to multiple addressees? If you're suggesting something different, then I do need further explanation. What does "make a new address box in Outlook" mean? And how would I import the CSV file into it? And how would I perform the merge from whatever that thing is? Thanks for your patience!

RichieMe :

no problem!

RichieMe :

and note I only get paid when you click Accept

RichieMe :

now what I meant is this

RichieMe :

put all the different contact addresses in to main address list in the exported Excel list

RichieMe :

seperated by a ;

RichieMe :

eg: joe @ me.com;Joe @ work.com; Joe 2 home.com

RichieMe :

once done, them make a new profile in Outlook by click Start, Control Panel, Mail

RichieMe :

Go to profiles, and add a new one

RichieMe :

it can be any email adderess ect, we just want a new address book

RichieMe :

Then on the new profile, click File, Import, and import the CSV file into the address book

RichieMe :

this will have the contact with the multiple email addresses in the main email address

RichieMe :

you can then do the mail merge based on this new address book (contacts)

RichieMe :

does that make sense?

Customer:

Ah - yes. Now I do get it. Thanks very much, Richie. Best, JC

RichieMe :

your very welcome!

RichieMe :

please remember to click Accept

RichieMe :

and take care

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 16838
Experience: Over 15 year experience resolving Microsoft Office Issues
Richard and 4 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional