Sending mail via excel
 

Hi,

I have used the macro, where the VBA procedure in excel sends mail on
behalf of outlook. but every time it attempts to send a mail, outlook
gives a warning message that, another program is trying to send mails
on behalf.

Is it possible to disable this warning message. for one or 2 mails its
fine but when the number of mails to be sent is high, it is very
difficult to keep pressing the "Yes" button.

Please help.

Thanks,
Navin

Sending mail via excel
 

Try this page

http://www.rondebruin.nl/cdo.htm

"navin" wrote:

Hi,

I have used the macro, where the VBA procedure in excel sends mail on
behalf of outlook. but every time it attempts to send a mail, outlook
gives a warning message that, another program is trying to send mails
on behalf.

Is it possible to disable this warning message. for one or 2 mails its
fine but when the number of mails to be sent is high, it is very
difficult to keep pressing the "Yes" button.

Please help.

Thanks,
Navin

Sending mail via excel
 

Thanks. this is really helpful....

A1pro wrote:
Try this page

http://www.rondebruin.nl/cdo.htm

"navin" wrote:

Hi,

I have used the macro, where the VBA procedure in excel sends mail on
behalf of outlook. but every time it attempts to send a mail, outlook
gives a warning message that, another program is trying to send mails
on behalf.

Is it possible to disable this warning message. for one or 2 mails its
fine but when the number of mails to be sent is high, it is very
difficult to keep pressing the "Yes" button.

Please help.

Thanks,
Navin