Get E-mail info with Outlook GUID (Redemption, CDO?)

Posted on 2008-11-12
Last Modified: 2013-11-27
Hello all.

I'm using Outlook and Access 2003. I have an Exchange folder called eCounts that receives e-mail from a particular sender called  

I would like to import or link to the following data within Access:

Normalized Subject
Outlook GUID (as table's Primary Key)

I'd prefer to link to live data though if possible.

Once that data is in Access, then I can normalize the subject line and compare it with a Calendar database field.  Then, I'd like to write back to the Normalized Subject with the phrase "123PROCESSED321".

So I've looked into the Outlook GUID and apparently, I am unable to obtain it within VBA unless I'm on Outlook 2007 or use CDO, Extended MAPI, or Redemption references.

I've spent the majority of the day searching for example code to do so with little success and I'm lost.  

If anyone could provide me with an example code or wouldn't mind helping me grasp these other references, I'd really appreciate it.  

Thank you for your time and expertise!
Question by:Sahmara
    1 Comment
    LVL 76

    Accepted Solution

    Hi, Sahmara.

    I'm not clear on what object property you are talking about when you say "Outlook GUID".  I'm confused because Outlook items don't have a GUID.  The closest they have to that is the EntryID property which is not globally unique.  It is only unique to the message store the item is in.  If that is the field you mean, then EntryID is available without the need to use any of the items you listed.  Simply retrieve object.EntryID.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    My experience with Windows 10 over a one year period and suggestions for smooth operation
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    755 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