+ Reply to Thread
Results 1 to 7 of 7

Getting a outlook warning (2010) while sending an email through excel 2010 macro

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Getting a outlook warning (2010) while sending an email through excel 2010 macro

    Hi

    I am trying to send bulk emails from my excel 2010… however I am getting a POP UP. Please find the screen shot in the enclosed word document
    So every time a new mail is sent from excel we need to press the button allow
    Is there a way where I can turn off this warning…

    Thank youOutlook warning.docx

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Getting a outlook warning (2010) while sending an email through excel 2010 macro

    this may work

    Please Login or Register  to view this content.
    be sure to set it to True at the end of your module
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Getting a outlook warning (2010) while sending an email through excel 2010 macro

    Hi Judgeh

    could you please tell me where should I this could
    Please Login or Register  to view this content.
    [/CODE]

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Getting a outlook warning (2010) while sending an email through excel 2010 macro

    right after Public Function - turn it on

    turn it off right before End Function....

  5. #5
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Getting a outlook warning (2010) while sending an email through excel 2010 macro

    I am soryy I tired the way you have advised... but that didnt work well...
    is there any work around to it

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Getting a outlook warning (2010) while sending an email through excel 2010 macro

    that was my only thought.....sorry....maybe somebody else can jump in with a suggestion....

  7. #7
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Getting a outlook warning (2010) while sending an email through excel 2010 macro

    This error can only be avoid we have a valid anti virus software in the system... to check if we have the valid anti virus
    click - file - options- Trust center - Trust center settings- Programmatic access...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sending email whenever a cell is changed is MS Excel 2010
    By shaeto in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-26-2013, 01:39 PM
  2. Replies: 2
    Last Post: 11-12-2012, 04:41 PM
  3. Excel 2010 to auto-generate an email to recipients in outlook 2010
    By dmcmillo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 05:13 PM
  4. Having Excel 2010 auto-generate an email to recipients in outlook 2010
    By dmcmillo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2012, 08:23 AM
  5. [SOLVED] How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
    By new.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1