I'd use Word 2003. The good old mail-merge in Word (to print letters or labels) has been augmented to send e-mail.
And, like the 'old' mailmerge it can use data from Excel. Each row becomes an e-mail with variables filled in from that row.
Better test with your own email-address until it's perfect.
Hope this helps.
I have a question...
I run a music review e-zine and I spend a lot of time each month manually creating emails to various publicists and record labels. I gather the information for the emails using an Excel spreadsheet. I use Microsoft Outlook for my email.
Let's say I have three columns as below:
Email Address | Artist | Description
and I use more or less a form letter to request review copies of upcoming CD releases. Can I pull information FROM Excel TO Outlook consisting of:
Email address -- goes into the "send to" field for the email.
Artist and Description -- goes into the body of the email as a variable.
Can I do something like this with Excel and Outlook so that I can just do... well, something like a mail merge to get the emails sent rather than doing it all manually?
If anybody can help me out or even point me in the direction of how to do this (if it's do-able), I'd be eternally grateful!