Macro to send automatic emails.

Hi Team,

Iam writing an macro which will sends email to a group of people.I need a small favour iam doing an vlookup with other workbook in column B and if column B contains any #N/A then should select the next cell in column A and in the body of mail template should be like "The New customer is added to the list" otherwise should be "No new customers Added".

Thanks for all your help in Advance

Regards,
Shekar Goud.

ooops attachment.

Hi,

Could someone please help on the above.

Regards,
Shekar.