Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email in VBA - getting a warning before sending
I've got VBA code in Excel to send an email to alert someone after
executing my other code. However, I get a warning message that states, "A program is trying to automatically send email on your behalf. Do you want to allow this?" I do want to allow this, and I would prefer to allow it without the warning message. I've read that there isn't a way to disable this, but I'm hoping that's wrong. I did find other code that disabled warnings, but it wasn't specifically for an email warning. This code is: Application.DisplayAlerts = False Will this work for the email warning? (I would test it, but I'm not at work for the next 3 days). Thanks for any advice. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email in VBA - getting a warning before sending
No, that won't suppress it.
http://www.rondebruin.nl/sendmail.htm Ron discusses the use of CDO as a work around I believe. -- Regards, Tom Ogilvy "Phrank" wrote in message ... I've got VBA code in Excel to send an email to alert someone after executing my other code. However, I get a warning message that states, "A program is trying to automatically send email on your behalf. Do you want to allow this?" I do want to allow this, and I would prefer to allow it without the warning message. I've read that there isn't a way to disable this, but I'm hoping that's wrong. I did find other code that disabled warnings, but it wasn't specifically for an email warning. This code is: Application.DisplayAlerts = False Will this work for the email warning? (I would test it, but I'm not at work for the next 3 days). Thanks for any advice. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email in VBA - getting a warning before sending
Thanks Tom! I've read that now, and it leaves me wondering if it will
work on a network (I'm at home right now and can't test this until Monday). Do you happen to know if it does or not? Thanks Tom. Frank On Thu, 1 Feb 2007 22:44:51 -0500, "Tom Ogilvy" wrote: No, that won't suppress it. http://www.rondebruin.nl/sendmail.htm Ron discusses the use of CDO as a work around I believe. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email in VBA - getting a warning before sending
I have never had a need to use it myself.
-- Regards, Tom Ogilvy "Phrank" wrote: Thanks Tom! I've read that now, and it leaves me wondering if it will work on a network (I'm at home right now and can't test this until Monday). Do you happen to know if it does or not? Thanks Tom. Frank On Thu, 1 Feb 2007 22:44:51 -0500, "Tom Ogilvy" wrote: No, that won't suppress it. http://www.rondebruin.nl/sendmail.htm Ron discusses the use of CDO as a work around I believe. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email in VBA - getting a warning before sending
Hi Phrank
It depend if the IT people block it or not. But it is possible if the settings are OK Good news: Outlook 2007 have no problem anymore if you have good protection installed. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Phrank" wrote in message ... Thanks Tom! I've read that now, and it leaves me wondering if it will work on a network (I'm at home right now and can't test this until Monday). Do you happen to know if it does or not? Thanks Tom. Frank On Thu, 1 Feb 2007 22:44:51 -0500, "Tom Ogilvy" wrote: No, that won't suppress it. http://www.rondebruin.nl/sendmail.htm Ron discusses the use of CDO as a work around I believe. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email in VBA - getting a warning before sending
Thanks Ron. I've sent the file with the updated code to a friend at
work, and he's trying it out for me. I'll let you know what happens. Thanks again. On Fri, 2 Feb 2007 15:40:44 +0100, "Ron de Bruin" wrote: Hi Phrank It depend if the IT people block it or not. But it is possible if the settings are OK Good news: Outlook 2007 have no problem anymore if you have good protection installed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
removing sending mail warning | Excel Worksheet Functions | |||
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel | Excel Programming | |||
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel | Excel Programming | |||
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel | Excel Programming |