Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendmail macro problem in Excel | Setting up and Configuration of Excel | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Invoke Outlook Express SendMail From Excel VBA | Excel Programming | |||
Responding to Outlook Errors when useing Sendmail!! | Excel Programming | |||
SendMail and BCC | Excel Programming |