+ Reply to Thread
Results 1 to 2 of 2

Get collection of open emails (being edited)

  1. #1
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Get collection of open emails (being edited)

    Hi,

    I am working on an automation to create an email from an email template embedded in a worksheet
    all goes well, but for some reason I end up with an extra copy of the email open

    I've been searching and apparently it is quite limited the options when manipulating embedded files
    so I guess the best change I have is to get all open emails, and then check each of them and close this "extra" one that is generated

    I know I can use getObject() to get one item, but I'm not sure how can I get all of them

    then once I have them in a collection or array I can check each email properties and weed out the one I don't want

    can somebody help me out?

    thanks!

  2. #2
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Re: Get collection of open emails (being edited)

    in case somebody is wondering -- I found some solution
    the tricky part is that you need to wait a bit until the embedded email becomes available in outlook

    the collection of open emails can be read through the collection of inspectors
    I get the captions of all open emails to detect with one has been open

    doing it like this I do not get the double-email problem
    Feel free to ask for the fuctions called -- although they are not the key part
    ç

    Please Login or Register  to view this content.

+ 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. Open multiple workbooks in directory, copy a range to them for data collection
    By agutman50 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2014, 01:24 PM
  2. how to open the workbook and add into workboooks collection
    By yeekhoon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2007, 06:44 AM
  3. Replies: 3
    Last Post: 06-26-2006, 06:38 AM
  4. Collection tries to open /.xls
    By Tomkat743 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-19-2006, 11:15 PM
  5. Replies: 12
    Last Post: 12-28-2005, 06:55 AM

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