+ Reply to Thread
Results 1 to 2 of 2

Code to scrape system generated outlook email doesn't get all the data

  1. #1
    Registered User
    Join Date
    02-06-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2007
    Posts
    46

    Code to scrape system generated outlook email doesn't get all the data

    I am trying to adapt the code below for my use in excel to scrape information from an outlook email so that I can create a new record for an individual. I struggle to use arrays so this may not be the best way to do what I want but my questions are as follows.
    1. how do I get the macro to read off of another folder other than inbox?
    2. How do I get the macro to create a new line for each blankety blank coverage including the rest of the data listed above?

    I have scrubbed the data but you can get the idea.

    The email looks like this with a subject of:
    Action Required: Manually add employee, traditional coverage, not late

    Action Required: Manually add employee, traditional coverage, not late

    Customer ID: 0123456
    Customer Name: Blankety blank customer
    Billing ID: E1821129
    Billing Name: Blankety blank customer
    Payroll Frequency:
    Reason for Enrollment: New Applicant
    First Name: New
    Middle Initial:
    Last Name: Customer
    Suffix:
    Date of Birth: 99/99/9999
    Gender: F
    SSN: 123456789
    Employee ID:
    Date of Hire: 11/10/01
    Date Newly Eligible: 11/10/01
    Earnings: 100000.00
    Earnings Mode: A
    Eligibility Class: Blah Blah Blah
    Signature Date:

    Automatically Enrolled Coverages:
    Blankety Blank Coverage1 (Coverage Effective Date 10/28/2010)
    Blankety Blank Coverage2 (Coverage Effective Date 10/28/2010)
    Blankety Blank Coverage 3 (Coverage Effective Date 10/28/2010)
    Blankety Blank Coverage 4 (Coverage Effective Date 10/28/2010)
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    02-06-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2007
    Posts
    46

    Re: Code to scrape system generated outlook email doesn't get all the data

    bump no response.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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