Outlook e-mail merge from Excel data source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I send a form letter through e-mail using an Excel file as a data source?

Say, for example, that in my Excel worksheet is a table conatining student information like name, ID#, grade, ..., e-mail address. I'd like to generate e-mail messages (in Outlook, I have Office XP) that look like this:

To: <<e-mail address>>
From: (e-mail address removed)
Subject: Grade report for <<name>>

Contents:
(info from the Excel table specific for <<name>>)


Thanks for your help!
 
You would need a third-party tool or custom code to do this, since Word's
mail merge feature does not support merge fields in the subject. See
http://www.slipstick.com/addins/mail.htm#massmail for available tools that
work with Outlook.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Scott said:
How can I send a form letter through e-mail using an Excel file as a data source?

Say, for example, that in my Excel worksheet is a table conatining student
Click to expand...
information like name, ID#, grade, ..., e-mail address. I'd like to generate
e-mail messages (in Outlook, I have Office XP) that look like this:
 
Back
Top