LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default 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.

 
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
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email billbrandi Excel Discussion (Misc queries) 1 April 3rd 08 03:44 AM
removing sending mail warning Simon Excel Worksheet Functions 1 March 31st 08 02:19 PM
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel Macgru Excel Programming 0 April 14th 05 09:30 PM
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel Sunil Jayakumar Excel Programming 0 April 14th 05 11:11 AM
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel Fredrik Wahlgren Excel Programming 0 April 14th 05 10:53 AM


All times are GMT +1. The time now is 03:35 AM.

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

About Us

"It's about Microsoft Excel"