Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

In vba checking outlook mail items a read receipt .SentOn property is invalid

In  vba checking outlook mail items a  read   receipt  .SentOn property is invalid

How would you determine the date time from the properties ?

_Read: Subject:  R&M      INFORMATION ON XXXXXXX
__________________________________________________
Your message

    To:  xxxxxxxxxx
    Subject:  R&M      INFORMATION ON XXXXXXX
    Sent:  12/02/2015 1:06 PM

was read on 12/02/2015 5:49 PM.


Other emails such as replies the property senton is set.
0
leibhold
Asked:
leibhold
  • 3
  • 2
1 Solution
 
QlemoC++ DeveloperCommented:
The receipt is a ReportItem, and no MailItem. See https://msdn.microsoft.com/en-us/library/office/ff865370(v=office.15).aspx for members.
As it seems the CreationTime is what you are looking for. If you also need the corresponding mail item, you will have to perform a search based on the ConversationID.
0
 
leibholdAuthor Commented:
Thank you  - explains the issue

I didn't realise that the folder could contain items other than mailitems  - I will check item type first then based on the type obtain the correct information.

Thank you
0
 
leibholdAuthor Commented:
Clear and concise help - thanks
0
 
QlemoC++ DeveloperCommented:
Each folder in Outlook can contain different item types. The folder defines the default type only.
0
 
leibholdAuthor Commented:
Yes - my code looks into the mail folder for returned emails on a subject basis.
This goes into an access job database where the outgoing emails are created.
When a person replies, it looks at the subject, finds the order number and updates the job with the returned email.
It was starting to get confused when the READ: messages started turning up.

With the change, I can now separate to replies from the read receipts.

Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now