I have created a script that moves new emails in the inbox into an Excel worksheet. The email's subject, body, sender, sent time/date, and number of attachments are all logged in the worksheet formatted correctly. The script runs when a new mail item is placed into the inbox, it then looks at each mail item in the inbox and if an item is .unread = true it will progress through the code and set it as .unread = false. Outlook is set to organizes organize and consolidates emails by conversations. Although I want the first email from when a conversation starts to be transferred into excel, I do not want any replies or the rest of the email dialogue to be transferred. Is there any preferably vba code or other methods available that would allow us to check if an email is the first in the conversation, and if it isn't skip it?
Bookmarks