Hello
Look for ExpressClickYes to download (it's free) and it sends Ok to these
Outlook Messages

HTH
Cordially
Pascal

"navin" a écrit dans le message de news:
...
Hi,

I wrote a macro in excel, which sends mail through Outlook. However,
before the mail goes, it prompts the user asking if they want to send
the mail. when the number of mails are huge, it is very difficult to
keep pressing the yes button.

I tried using CDO as well but no success due to error, "sendusing
configuration error". Please let me know if the alert given by outlook
can be disabled somehow or any other solution.

Thanks,

Navin