Email Merge

[Man]

I'm sending a lot of emails offer to a lot of candidates.

How can I let outlook by providing information from a DATA SOURCE as below:
1- Candidate Name.
2- Basic Salary ( we use excel just butting the Salary and it provide us
with the rest of the calculations and information in the same table)
3- Status: Family, HRA, Single (we have three categories in three sheets for
each case).
1- Candidate email.

And in different subjects I want for each email

Subject: Offer-Candidate Name- basic salary - status - today date- my name.
CC field : I want to but my manager email address.

Is there is a way to do that.

 

[Sue Mosher [MVP-Outlook]]

You can handle the data source by adding more fields to Outlook. Right-click the column headings in any table view of the contacts folder and choose FIeld Chooser.

But to customize the subject of outgoing messages in a merge, you'll need a third-party utility; see http://www.slipstick.com/addins/mail.htm#massmail

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

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