Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with outlook
I am using XL 2003 to send out emails to about 50 clients. However when I do
this Outlook 2003 comes up with a dialog stating that I am automatically sending out an email and I have to client on the Yes button 50 times. I know this is a very good feature but for the purposes of my macro can I turn it off and then back on after the macro has finished Many thanks James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with outlook
Hi James
See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl " wrote in message ... I am using XL 2003 to send out emails to about 50 clients. However when I do this Outlook 2003 comes up with a dialog stating that I am automatically sending out an email and I have to client on the Yes button 50 times. I know this is a very good feature but for the purposes of my macro can I turn it off and then back on after the macro has finished Many thanks James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with outlook
Sorry Ron but the'check mark from the warn me when other
applications try to send mail as me check box' is not there. I'm using Outlook 2003 with Exchange. Any other ideas? Thanks "Ron de Bruin" wrote: Hi James See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl " wrote in message ... I am using XL 2003 to send out emails to about 50 clients. However when I do this Outlook 2003 comes up with a dialog stating that I am automatically sending out an email and I have to client on the Yes button 50 times. I know this is a very good feature but for the purposes of my macro can I turn it off and then back on after the macro has finished Many thanks James |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with outlook
Hi
Sorry Ron but the'check mark from the warn me when other This is for Outlook exppress See the Outlook and CDO part of the page -- Regards Ron de Bruin http://www.rondebruin.nl " wrote in message ... Sorry Ron but the'check mark from the warn me when other applications try to send mail as me check box' is not there. I'm using Outlook 2003 with Exchange. Any other ideas? Thanks "Ron de Bruin" wrote: Hi James See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl " wrote in message ... I am using XL 2003 to send out emails to about 50 clients. However when I do this Outlook 2003 comes up with a dialog stating that I am automatically sending out an email and I have to client on the Yes button 50 times. I know this is a very good feature but for the purposes of my macro can I turn it off and then back on after the macro has finished Many thanks James |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with outlook
Get a small add in called click yes. It is wonderful and very easy to use.
It does all the clicking for you and is very fast " wrote in message ... I am using XL 2003 to send out emails to about 50 clients. However when I do this Outlook 2003 comes up with a dialog stating that I am automatically sending out an email and I have to client on the Yes button 50 times. I know this is a very good feature but for the purposes of my macro can I turn it off and then back on after the macro has finished Many thanks James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Outlook Automation Error Problem - Can't locate Outlook Module | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming | |||
Display mail application either in Outlook, or Outlook express | Excel Programming |