Consulting

Results 1 to 3 of 3

Thread: Filtering Subject and creating Categories

  1. #1

    Post Filtering Subject and creating Categories

    Hi,

    Yes i'm new to this forum and I must say it's great I have some past experience with scripting in the past using MaxScript (3D software in-house scripting language) but this VBA stuff is a bit extreme for me now.

    I looked at different post in the forum and couldnt quite find the information I was looking for. So here I am posting on my own.

    What I need to do is to filter the subject of my mails. The thing is I get message with subject generated by a bug database software that look like this :

    [JIRA] Assigned: (QCKEL-1610) Flickering elements in 01_Casino_01
    [JIRA] Assigned: (KEL-1245) Flickering elements in 01_Mexico_03
    [JIRA] Closed: (QCKEL-1610) Flickering elements in 01_Casino_01

    I would love to sort them using "Conversation" but since the subject line is changing it doesnt work. So what I tought is creating a script to filter the stuff in between the ( ) and create a Categorie with that string. This way I could sort my mails using Categorie and the mails that have the same "bug number" would be grouped together.

    I hope i'm clear enough :P

    Thx in advance!

    -- Christian

  2. #2
    VBAX Expert
    Joined
    Jul 2004
    Location
    Wilmington, DE
    Posts
    600
    Location
    Christian,

    What version of Outlook do you use? Outlook 2000 writes the Master Category List to the Registry as plain text, but XP and 2003 use binary...
    Regards,

    Patrick

    I wept for myself because I had no PivotTable.

    Then I met a man who had no AutoFilter.

    Microsoft MVP for Excel, 2007 & 2008

  3. #3
    It would be Outlook 2003.

    Thx!

Posting Permissions

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