[AccessD] Unusual problem processing Outlook emails

Heenan, Lambert Lambert.Heenan at aig.com
Tue Feb 13 11:23:02 CST 2018


What are the error generated?

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe O'Connell
Sent: Tuesday, February 13, 2018 12:06 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Unusual problem processing Outlook emails

Access 2013 application has a module that monitors an Outlook 2013 Inbox.  When an email is received it needs to be parsed and various actions taken depending on who sent the email, the subject and the contents of the body.  This has worked flawlessly for years using these properties:
olItem.Subject
olItem.CreationTime
olItem.SenderName
olItem.Body

Now a few emails have been received that generate errors when these properties are referenced:
olItem.SenderName
olItem.Body
The Subject and CreationTime still work as expected. 

All emails display properly in Outlook, but the actual format of the emails must be different to generate the errors when VBA attempts to retrieve the properties.

I have not been able to find out why this is happening.  All suggestions on how to deal with these errors will be greatly appreciated.

Joe O'Connell



More information about the AccessD mailing list