SendMail with Excel VBA - Outlook

[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

 

[Bob Phillips]

See this page http://www.rondebruin.nl/mail/prevent.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[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