Code to send a email via Macro in excel
 

Dear All,

I have one excel workbook with few sheets, in which I am copying out some
data/records from one sheet to another , based on certain conditions, using a
macro.

Now I have to send notifications via EMAIL to users , let say If there was
any error during above processing or If no error how many records copied
successfully.

I have to count value stored and perhaps error code also can capture. But
how to send those details in a mail , I am struggling to find out.

Kindly advise.

Thanks in advance,
Sunil Somani

Code to send a email via Macro in excel
 

Ron helps you:
http://www.rondebruin.nl/sendmail.htm
Stefi


€žSunil Somani€� ezt Ã*rta:

Dear All,

I have one excel workbook with few sheets, in which I am copying out some
data/records from one sheet to another , based on certain conditions, using a
macro.

Now I have to send notifications via EMAIL to users , let say If there was
any error during above processing or If no error how many records copied
successfully.

I have to count value stored and perhaps error code also can capture. But
how to send those details in a mail , I am struggling to find out.

Kindly advise.

Thanks in advance,
Sunil Somani