+ Reply to Thread
Results 1 to 3 of 3

Problem with Dynamic Delivery (ATP) and VBA in Outlook

  1. #1
    Registered User
    Join Date
    03-10-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    1

    Problem with Dynamic Delivery (ATP) and VBA in Outlook

    Since a few weeks the company I work for enrolled ATP functionality in Office 365.
    When I get a mail with an attachment the attachment is replaced with the
    message "ATP scan in progress" until it is released by ATP.

    I have some messages which will be picked up by a VBA macro and automatically
    save the attachments to a network share.
    When de macro starts, it uses Outlook.MailItem for the incoming mail, as long as
    the macro is running, Outlook.Mailitem is not refreshing, so I cannot access the
    attachment.

    Is there a way to wait for the attachment to be released and then continue with
    the macro?

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Problem with Dynamic Delivery (ATP) and VBA in Outlook

    Quote Originally Posted by Odouma View Post
    When de macro starts, it uses Outlook.MailItem for the incoming mail, as long as
    the macro is running, Outlook.Mailitem is not refreshing, so I cannot access the
    attachment.

    Is there a way to wait for the attachment to be released and then continue with
    the macro?
    what do you mean that the mail item is not refreshing? it's not supposed to. mail items don't do that on their own. and furthermore, code like yours isn't supposed to do that either. and regarding the waiting for ATP to finish what it does before getting the attachment from the item, I seriously doubt it. ATP obviously is Microsoft's attempt as being a virus checking program. and of course, that's not their specialty. furthermore, it makes absolutely no sense that a service like ATP would be able to communicate with an office product's coding environment, because ATP is an ancillary service and rolled out for a different purpose by MS. I could be wrong though.

    If there actually was a library that could be used to point to any running process involved in the ATP service from MS, more than likely MS would not have developed it and rolled it out with the ATP service because the people who are buying this service from MS are not developers.

    and on a side note, which you should be aware of, is that rollouts like this from MS, Google, Amazon, Apple and any other big player will continue to cause problems in terms of trashing legitimate messages from people who do not intend to cause any harm, whether it be messages that have links in them, files attached to them or whatever. The reason for this is simply because large players like these continually forget that people who are just starting out in the business and/or are offering differentiating services sometimes get flagged by big companies because they are seriously behind the ""leading edge"" that was created by MS and other companies many decades ago. So....in essence, what that means, is that large corporations cause much more frustration than they're actually worth, and the only reason business leaders buy these types of services is so that they can keep the B2B environment alive and promote that they are ""creating value"" for their organization. When in all reality, they are creating more problems than they are solving.

    https://docs.microsoft.com/en-us/mic...o365-worldwide
    Last edited by vba_php; 09-04-2020 at 10:40 AM.

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Problem with Dynamic Delivery (ATP) and VBA in Outlook

    @Odouma

    Are you still using Office 2010? Or are you using Office 365?

    I assume Office 365, since ATP is Azure based service for advanced threat detection.

    In Office 365 ecospace, I do not recommend use of VBA to interact with mails. Rather, use MS Power Automate (Flow) to perform automated action.
    There are plenty of pre-made templates to suite your need and it's low-code method to automate process.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. [SOLVED] Return Delivery Date or state 'No Delivery'
    By jimbokeep in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2019, 11:51 AM
  2. Create Outlook mail with dynamic .Body and static .HTMLBody
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2014, 04:45 AM
  3. Replies: 2
    Last Post: 06-05-2013, 12:14 PM
  4. Microsoft outlook 2003 - Delay the delivery of a single message
    By EmmaGreen in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 11-21-2012, 07:47 AM
  5. Data Validation - Excel and Outlook Delivery
    By Ray789 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2011, 09:23 AM
  6. Outlook Automation Error Problem - Can't locate Outlook Module
    By Allan P. London in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2005, 06:05 PM
  7. [SOLVED] Delivery note or delivery order sheet
    By Roy Istanbouli in forum Excel General
    Replies: 1
    Last Post: 01-21-2005, 02:06 PM

Tags for this Thread

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