+ Reply to Thread
Results 1 to 3 of 3

separating outlook subject line into columns

  1. #1
    Forum Contributor
    Join Date
    09-01-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, Excel 2013, Excel 2016
    Posts
    115

    separating outlook subject line into columns

    I have the below code that I am trying to modify to split a subject line into to six columns to view in Excel.

    Please Login or Register  to view this content.
    My data is in the below format (please note that this is subject line information only - the body of the email is not required)

    SLWP Ottawa | Sales Eng. | 26-Jun-15 | Shift End: 21:00 | Leave Time: entire day | SLWP (Unpaid)
    SLWP Brampton | Sales Eng. | 26-Jun-15 | Shift End: 19:00 | Leave Time: entire day | SLWP (Unpaid)
    SLWP Ottawa | Sales Eng. | 26-Jun-15 | Shift End: 16:00 | Leave Time: 12:15 | SLWP (Unpaid)

    I will like to have it split into the following column headers:

    Column A will be - Sender
    Column B will be - Location
    Column C will be - LOB
    Column D will be - Date
    Column E will be - Shift End Time
    Column F will be - Requested Leave Time
    Column G will be - Paid / Unpaid

    Any help will be most appreciative.

    I also tried to modify the code with the below but still to no avail

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-01-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, Excel 2013, Excel 2016
    Posts
    115

    Re: separating outlook subject line into columns

    With some research and some help I came up with the below code that splits the subject line

    Please Login or Register  to view this content.
    However the code fails when the month is written in French as per below

    The code is failing at the below highlighted date in the CDate(vSubject(2)) part of the code with a Type MisMatch error.

    SLWP Montreal | Care Help Desk Fr. | 27-juin-15 | Shift End: 16:00 | Leave Time: entire day | SLWP (Unpaid)

    In contrast if written as

    SLWP Montreal | Care Help Desk Fr. | 27-jun-15 | Shift End: 16:00 | Leave Time: entire day | SLWP (Unpaid)

    no issues.

    Is there a way around this issue that any of you can assist me with?

    Thanks in advance

  3. #3
    Forum Contributor
    Join Date
    09-01-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, Excel 2013, Excel 2016
    Posts
    115

    Re: separating outlook subject line into columns

    I did a quick modification that solve the issue.

    Final code is

    Please Login or Register  to view this content.

+ 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. Open Outlook Template and Need Subject Line
    By TMcKay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2015, 05:21 PM
  2. Outlook 2013 Copy Body and Subject Line
    By wrasser in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-12-2015, 03:54 PM
  3. Outlook Subject line from Excel Cell reference
    By Shibu.excel in forum Outlook Formatting & Functions
    Replies: 4
    Last Post: 09-06-2012, 03:19 AM
  4. Subject Line Alert - Outlook 2007
    By dreinisch in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 09-12-2011, 09:43 AM
  5. Changing the Outlook subject line...
    By ChrisMattock in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2009, 10:19 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