|
Posted to microsoft.public.excel.misc
|
|
|
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
|