[AccessD] Unusual problem processing Outlook emails

[Joe O'Connell]

Sorry, I forgot to include it: "Run-time error 438 Object doesn't support this property or method"

Joe


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

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com