Linking Outlook mailing to Excel data lists

[Guest]

The issue is:
One Excel spreadsheet containing loads of emails of potential clients,
client names and business names.
One desire to send a personalised email to each along the lines of:

Dear CLIENTNAME, we provided blah blah blah for your BUISNESSNAME yet more
blah BUSINESSNAME and end of blah,
end of message.

Naturally the blah etc will be relevant to the buisness offer!
Does anyone know of a way of linking up Outlook and Excel so that Outlook
will take the email address for each person from Excel, insert the fields
CLIENTNAME and BUISNESSNAME at the proper places and then send each
personalised message out?

 

[Roady [MVP]]

Use a mail merge. You can start it from within Word.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----
The issue is:
One Excel spreadsheet containing loads of emails of potential clients,
client names and business names.
One desire to send a personalised email to each along the lines of:

Dear CLIENTNAME, we provided blah blah blah for your BUISNESSNAME yet more
blah BUSINESSNAME and end of blah,
end of message.

Naturally the blah etc will be relevant to the buisness offer!
Does anyone know of a way of linking up Outlook and Excel so that Outlook
will take the email address for each person from Excel, insert the fields
CLIENTNAME and BUISNESSNAME at the proper places and then send each
personalised message out?