Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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?



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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?



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Notification to my email address tompl Excel Discussion (Misc queries) 3 March 11th 10 01:11 PM
Email Notification of Responses JLatham Excel Discussion (Misc queries) 2 January 26th 10 02:38 PM
Changing email notification address Dale Fye Excel Discussion (Misc queries) 1 August 6th 08 01:52 PM
Email notification of answer posted jfg Excel Discussion (Misc queries) 10 July 7th 08 06:46 PM
email Notification from Excel bobbyfaescotland Excel Discussion (Misc queries) 1 July 20th 06 06:19 PM


All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"