Email

[Frank - PA]

I want to use a Send Email button in excel to send an email to all my clients located in the spreadsheet using an Outlook Template.

I have some clients with multiple records and others with just one record. For those with multiple records I would like to include all the records in one email. below is a sample of what I would like to send.

Issue Id Title Tracker Owner BAC Analyst Status Business Module Processing Status Environment
QRY13168 Title one Tom Jones Jerry Jones Open MSE - Ready for Test PQA
QRY13513 Title two Tom Jones Jerry Jones Open MSE - Ready for Test PQA
QRY13515 Title three Tom Jones Jerry Jones Open MSE - Ready for Test PQA
QRY13518 Title four Tom Jones Jerry Jones Open MSE - Ready for Test PQA
7394 Title five Chris Jackson Jerry Jones Open MSE - Ready for Test UAT
13372 Title six May Baxter Jerry Jones Open MSE - Ready for Test PROD

[alansidman]

Google Ron deBruin. He is the foremost guru on emailing from excel. He has a whole web site dedicated to this topic.

Alan