+ Reply to Thread
Results 1 to 2 of 2

Attachments Collection

  1. #1
    Registered User
    Join Date
    11-09-2016
    Location
    London, England
    MS-Off Ver
    2010/2016
    Posts
    71

    Attachments Collection

    Hello,

    I am automating the saving of e-mails and their attachments.

    One thing I have came across is that the attachments collection includes embedded things (images for example). I've seen a couple of ways of handling this:

    check the file extension
    check the file size
    use the proptag to determine real attachments

    However, neither work for me because I only want to exclude signature images. I've seen signature logos that are bigger than some of our PDF files. If an e-mail contains an actual inline image that is part of the content of the e-mail (a screenshot for example), that should be included in the attachments collection. If any image is actually properly attached, that too should be included in the attachments collection.

    We deal with technical drawings and they could equally be embedded or attached. Is this possible?

    Thanks

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    274

    Re: Attachments Collection

    This one could be tough.

    note, embedded images have CID/ContentIDs so filtering down to just the last embedded images using the MailItem.HTMLBody and Attachment.PropertyAccessor should be doable
    Please Login or Register  to view this content.
    (you might even be able to squeeze out how close the image is to a Sender/To/CC name within the body relative to the size of the body)

    the next question I'd have is how/where are you saving your archive copies? in a database, pst file, msg/html files with attachments in a folder, ...
    If it'd make you feel better using my answer because of my street cred, then you can go ahead and click Add Reputation below to improve it.

+ 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] Adding a collection to a collection.
    By Max_Taylor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2018, 12:22 AM
  2. Replies: 4
    Last Post: 10-30-2015, 01:30 PM
  3. Send multiple emails with different attachments if attachments found
    By AnkitJain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2015, 05:35 AM
  4. [SOLVED] Performance of iteration through Words collection degrades as collection gets bigger
    By 6StringJazzer in forum Word Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2014, 09:44 AM
  5. User form to add attachments and send the form and attachments via outlook
    By scorchio83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2013, 03:46 AM
  6. Replies: 2
    Last Post: 12-23-2011, 11:04 AM
  7. Problems storing a Collection within a Collection. Is this possible?
    By Tarball in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2007, 10:47 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