I'm using Outlook and Access 2003. I have an Exchange folder called eCounts that receives e-mail from a particular sender called firstname.lastname@example.org.
I would like to import or link to the following data within Access:
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!