+ Reply to Thread
Results 1 to 2 of 2

Differentiating Between Mail That is a Response in a Conversation

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    Massachusetts, USA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Differentiating Between Mail That is a Response in a Conversation

    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?

  2. #2
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Differentiating Between Mail That is a Response in a Conversation

    Try PR_LAST_VERB_EXECUTED described here http://www.slipstick.com/developer/r...-object-model/

    Please Login or Register  to view this content.
    To mark "Solved" go to Thread Tools.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date/ Time conversation when all in same cell
    By sara143 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2014, 09:01 AM
  2. Copying Categories from Conversation to E-Mails
    By bdavjd in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2014, 09:54 PM
  3. Filter message according to conversation in Outlook
    By shum2934 in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2013, 02:12 AM
  4. [SOLVED] Formula for area conversation
    By Akhilesh Dalia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2006, 08:10 AM
  5. Replies: 0
    Last Post: 12-22-2005, 03:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1