Link to home
Start Free TrialLog in
Avatar of Sahmara
SahmaraFlag for United States of America

asked on

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

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:

Subject
Body
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!
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial