Create Auto Email in Outlook from Excel if conditions are met

Team,

I am looking for VBA code which will auto-check if in Column B or C and extract the list from Column D and paste it in Email body with prefix email body.

Attached is sample data i would expect the email should go to "[email protected]" and in the email body the name should A, B, C & D.

Thanks,

Anybody has the answers?

http://www.mrexcel.com/forum/excel-q...date-cell.html try the code listed here it may take some modification to fit your workbook. I had a similiar problem and this is the solution that I used.

Thanks Clabhart .. i found the solutions yesterday through below link

http://www.rondebruin.nl/win/s1/outlook/amail8.htm