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

Posted on 2008-11-12
Medium Priority
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 ecounts@count.com.  

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

David Lee earned 2000 total points
ID: 22946502
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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

807 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