[AccessD] Unusual problem processing Outlook emails

James Button jamesbutton at blueyonder.co.uk
Tue Feb 13 15:31:57 CST 2018


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



More information about the AccessD mailing list