Excel to Outlook mail merge

[Guest]

I have an Excel spreadsheet with email and other information on 2,000 people,
with the headings in the first row. I want to send out an e-blast to
everyone on the list using information fromt the spreadsheet in the body of
the message.
I created a Contact group called 2007Convention.
I named the ranges in Excel by using Insert, Name, Define.
I was able to use File, Import and Export, Import from another program or
file, Microsoft Excel (do not import duplicate items), and selected the
contact group 2007Convention as the destination folder. On the next page, for
each named range in Excel, I checked the Excel field, and in the new window
linked the Excel named ranges to Outlook field names.
Now I would like to send an email using the information in the named ranges
"status mapped to user1", "type mapped to user2", first name, last name. Can
you tell me how to do that? Insert Field did not bring up the fields I
needed. Thanks.
Irim Siddiqui

 

[Sue Mosher [MVP-Outlook]]

Skip the contacts and just use the Excel sheet as the data source for the mail merge in Word.

Or, if you already have the contacts, display the contacts folder, then choose Tools | Mail Merge in Outlook and follow the prompts. If you do that, you'll have access to all the fields in Word.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers