SendMail with Excel VBA - Outlook
 

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

--
Message posted from http://www.ExcelForum.com

SendMail with Excel VBA - Outlook
 

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)

"Bo_ " wrote in message
...
Within a procedure in VBA (Excel), I send out a number of workbooks with
SendMail (MAPI).

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

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

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

Is it possible to make this dialogbox NOT to appear ?


---
Message posted from http://www.ExcelForum.com/

SendMail with Excel VBA - Outlook
 

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

Bo_ wrote in message ...
Within a procedure in VBA (Excel), I send out a number of workbooks with
SendMail (MAPI).

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

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

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

Is it possible to make this dialogbox NOT to appear ?


---
Message posted from http://www.ExcelForum.com/