ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Email notification (https://www.excelbanter.com/excel-programming/292704-email-notification.html)

kELLY

Email notification
 
I have written a macro that automatically sends out an
email.
The problem is that when it runs, I get a microsoft outlook
box wanting me to confirm that it is ok to send. Can I
write something that will bypass this message?

Ron de Bruin

Email notification
 
Hi Kelly

http://www.rondebruin.nl/sendmail.htm#Prevent
See the Outlook or CDO part

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"kelly" wrote in message ...
I have written a macro that automatically sends out an
email.
The problem is that when it runs, I get a microsoft outlook
box wanting me to confirm that it is ok to send. Can I
write something that will bypass this message?




kELLY

Email notification
 
Thanks Ron,
On the Oulook, I don't have the option you suggested. Any
other suggestions?
I don't think I want to do the CDO part.

-----Original Message-----
Hi Kelly

http://www.rondebruin.nl/sendmail.htm#Prevent
See the Outlook or CDO part

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"kelly" wrote in

message ...
I have written a macro that automatically sends out an
email.
The problem is that when it runs, I get a microsoft

outlook
box wanting me to confirm that it is ok to send. Can I
write something that will bypass this message?



.


Ron de Bruin

Email notification
 
On the Oulook, I don't have the option you suggested

You find two links there to programs that you can use
Try Click Yes

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Kelly" wrote in message ...
Thanks Ron,
On the Oulook, I don't have the option you suggested. Any
other suggestions?
I don't think I want to do the CDO part.

-----Original Message-----
Hi Kelly

http://www.rondebruin.nl/sendmail.htm#Prevent
See the Outlook or CDO part

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"kelly" wrote in

message ...
I have written a macro that automatically sends out an
email.
The problem is that when it runs, I get a microsoft

outlook
box wanting me to confirm that it is ok to send. Can I
write something that will bypass this message?



.





All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com