[AccessD] Unusual problem processing Outlook emails

Joe O'Connell JoeO at appoli.com
Tue Feb 13 22:21:48 CST 2018


Jim,

Thanks for the suggestion.  I have never tried to view the headers, what is the best way to view them?  Could there be something in the header that makes the Outlook object think that there is no body in the email?

Joe


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James Button via AccessD
Sent: Tuesday, February 13, 2018 4:32 PM
To: 'Access Developers discussion and problem solving'
Cc: James Button
Subject: Re: [AccessD] Unusual problem processing Outlook emails

Also -
Have you viewed the headers on the problem emails and compared them against ones that do not generate problem messages Maybe the header contains alternate fields, or massively long and/or random character effect entries as may be associated with source obfuscation or just a different emailer or version of email software such as iphone etc.

I frequently copy and paste headers into a text file for source checking Or save the message and view it using a basic text viewer 

JimB

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Tuesday, February 13, 2018 5:23 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
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

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



More information about the AccessD mailing list