SendMail with Excel VBA - Outlook

B

Bo_

Within a procedure in VBA (Excel), I send out a number of workbooks wit
SendMail (MAPI).

Each time this procedure runs, I get the following message on th
screen : (Microsoft Outlook):

A PROGRAM IS TRYING TO AUTOMATICALLY SEND E-MAIL ON YOUR BEHALF. D
YOU WANT TO ALLOW THIS?

Until the user answers this dialogbox, the procedure does not continu
but waits for the user input.

Is it possible to make this dialogbox NOT to appear
 
P

Paul Robinson

Hi
You need the CDO Library (CDO 6.0??) which is NOT part of the standard
Outlook installation. Look through
microsoft.public.outlook.program_vba on the details of CDO and where
to get it.
regards
Paul
 
Top