Mail Merge from Excel to Outlook

Is there a way to take information from Excel and move it into an Outlook message? We have basic information on each line of an Excel sheet including the name of person and the email address. We would like to be able to move the email address to Outlook and have the persons name appear e.g. Dear Mr. Smith in the body of the message along with a stardard letter. I guess this would be similiar to a mass mailing. The process for this is as follows - a person in need of a service enters the information (email address, name, type of service needed, etc) on a specific web site and requests the cost of that service. The worker would log into the web site and transfer the basic information into an Excel spread sheet. The worker then wants to email the potential customer to make him/her aware of their companies available products. It is then up to the potential customer to telephone of email the worker back. To clarify the service - it relates to insurance. The worker may deal with up to 1,000 requests per week so the process has to be quick and easy to complete. Thank you
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Simple step by step from microsoft -->
GeneratorAuthor Commented:
Jingtam82 - this would be very work intensive. Looking for a quick solution where the user can capture a group of cells and get them into Outlook. Thanks
The only thing intense about the steps in Jingram's link is to look and see the number of steps to follow.  But take a minute and you'll find that it is pretty much straight forward and as easy as it might get.
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

I agree, this process can be completed in about 3 minutes tops.
Maybe you can use the procedure below to define your VBA function to send e-mails directly from Excel.
sub send_message()
    Dim objOutlook As Outlook.Application
    Dim objOutlookMsg As Outlook.MailItem
    Dim objOutlookRecip As Outlook.Recipient
    Set objOutlook = CreateObject("Outlook.Application")
    Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
    With objOutlookMsg
        Set objOutlookRecip = .Recipients.Add(agentemail)
        objOutlookRecip.Type = olTo
        .Subject = " subject "
        .HTMLBody = "Dear Sir"
        For Each objOutlookRecip In .Recipients
      SendKeys ("{pgdn}")
      SendKeys "^v", 5
    End With
    Set objOutlook = Nothing
End Sub

Open in new window

I just re-read your request.
It seems you don't just want to move the address into outlook.  You need to mail merge to email addresses.
Setup a mail merge document type "E-mail messages" with the Excel file as your data source.
You can filter the Excel file each time you need to elimiinate names from the merge.
Try it yourself first then give a shout if you need help with it.
Setup Mail Merge in Word.
GeneratorAuthor Commented:
Etircet - sounds good. Can you step me through the process involved - I have never set up Mail Merge in Excel or Word. Being that the information is on an Excel spread sheet I would be grateful if you could give me the steps involved. I need to be able to move the email address and the persons name into an Outlook message quickly. Presently one of our employees is spending most of her day cutting and pasting the email address and persons name from the spread sheet into an Outlook messsage containing a form letter in the body of the message.  Thanks
How many fields do you have in Excel and what are the names?
Maybe you can attach an excel file, with just the field names if information is sensitive, so I can try to determine the best way for you to set it up.
Just examples of the names will do, but I need to know how many fields.
GeneratorAuthor Commented:
I will get that information to you on Monday - Thanks
GeneratorAuthor Commented:
Etircet - I have attached a modified spread sheet (changed the names etc.) but it shows the fields. Thanks
Save and close your Excel file, then open Word.
Instructions as follows:
Tools, Letters and Mailings, Mail Merge.
Select document type E-mail messages.
Next: starting document
Select Use the current document or Start from existing document (open document if it already exists).
Next: Select recipients.
Select recipients Use an existing list.
Browse to select list created in Excel.
Next: Write your letter.
Select More Items to view list of fields.
Insert Merge Field will display list of fields from the Excel file you selected.
Select Match Fields
(This will show you a list of Outlook fields to match them to.  They dont all have related names to match to so you will have to substitute names for available ones.)

Match fields as follows:
  Client Name TO Last Name
  Company TO Company (same will already be matched)
  Date TO Address1
  City TO City
  No. of Vehicles TO Nickname
  Rank TO Jog Title
  Rate TO Department
  Successful if yes& TO Address2
  Reason not successful       TO Address3
  Client Phone TO Business Phone
  Client E-mail TO E-mail Address
  Date e-mailed client response TO Spouse Last Name
  Date Follow-up call TO Spouse Nickname

Next: Preview your e-mail messages
Use button arrows left and right to view individual messages.
You can make any individual changes doing this.
Selecting Electronic mail will SEND ALL MESSAGES VIA EMAIL.  You can always go back to preview to previous step on your mail merge task pane.

Let me know if you have any problems.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GeneratorAuthor Commented:
Etircet - I'm unable to create the mailing list from the Excel file. When I "Browse to select list created in Excel" it does not pickup the name list. Help!
Are you browsing to the that contains you Excel file?  Make sure the file is created and saved to a location you have access/rights to.  What do you see?  Are you looking for an .XLS file?  Once the file is created, you should be able to view it.
GeneratorAuthor Commented:
I have no problem locating the Excel file. When I go through the steps in Word and get to adding the recipients - the Mail Merge Receipient window pops up but there are no fields related to the headings on the spreadsheet - this is as far as I get. The entries that are there relate to some additional information on Sheet 2 of the Excel file. I have attached a screen shot. Thanks
That means you selected sheet 2 as your table.
Go back to the previous step and select the correct sheet.
You might even do better to go back to the beginning and open the excel sheet and save as a different name then delete all but the one sheet you need, then save and close then try the merge again.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.