Code to send a email via Macro in excel

  • Thread starter Thread starter Sunil Somani
  • Start date Start date
S

Sunil Somani

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
 
Back
Top