Click Email in Excel and Populate Form Message in Outlook

Hi everyone,

I have an excel 2003 spreadsheet with a list of emails. I was wondering how I could click any one of those email links and have it open outlook 2003 (which it already does automatically) with my confirmation template already placed in the body of the email (which it obviously does not do automatically). If it's relatively simple to have it populate a standard email subject line as well that would be icing on the cake.

Thanks in advance.

You cant generate an auto email subject from Excel. You would ahve to have an emailer program and have subjects alreay set up and import your email addresses that way.
Im assuming that you have a newsletter that you send out.