How do I disable the pop that comes in outlook when my tool tries to capture data.

Posted on 2011-05-06
Last Modified: 2012-08-13
Hi Team,

I am building a tool in excel that will extract all the data from the given Inbox's to the tool.  but the attahced pop up comes to the user and he has to click each time.

How I stop the same.
Question by:Sandesh555
    LVL 7

    Accepted Solution

    You can't ... at least not while you are automating an Outlook session.  This pop-up was put in place to prevent script kiddies mass mailing junk from your PC back in the days of Outlook 2000.  If you use Outlook 98 or even a pre-service release version of Outlook 2000 there will be no issue but the modern versions will prevent you from harvesting email addresses.

    You can use MAPI or CDO (instead of Outlook)  to get at the same information that will not generate a pup-up but automation of Outlook is going to be a problem.

    Hope this helps


    LVL 22

    Assisted Solution

    by:Nico Bontenbal
    You could use something like this:
    LVL 10

    Assisted Solution

    Using Outlook 2003 you have no choice; and the ClickYes tool only avoids you having to press Enter yourself, it doesn't kill the message. Outlook 2007 has an option to allow access by external progams (Tools, Trust Centre, Programmatic Access), so an upgrade will achieve the quiet operation that you want.


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now