• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • 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
    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.
  • 3
  • 2
1 Solution
QlemoBatchelor and 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.
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
leibholdAuthor Commented:
Clear and concise help - thanks
QlemoBatchelor and DeveloperCommented:
Each folder in Outlook can contain different item types. The folder defines the default type only.
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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