locked
Export text from outlook emails into excel RRS feed

  • Question

  • Hi-

    I have claims submitted to me via an online form which come to me email. For tracking/reporting purposes we have to then copy and paste this all into excel. With about 50 of these a day it is becoming overwhelming to review them and copy/paste all the data. I have tried to follow similar instructions found here but keep getting random errors. I have zero vba knowledge. I think the issues may have to do with repeat field names and the fact that there is one field name but there can be up to 8 entries on these. Below is a copy of the email. I only need the fields that are bold, italics and underlined to go to excel. Can anyone help out with a code for this? It would be much appreciated! 

    Claim form ID: 1111140144

    Service Technician Information

    Company

    Dandelion Productions

    Technician

    Colette Paul

    Phone

    698 555 1236

    Email

    1vbh@yahoo.com

    Street Address

    123 Garden Grove Blvd

    City

    Flower

    State or Province

    MN

    Zip code

    98765

    Country

    US

    Additional Email

    tmcs@163.com

    End User (Customer) Information

    Customer Region:

    APAC

    Serial Number

    CPXR53062

    Equipment Model

    CPX3000

    Main Contact

    Rose Williams

    Phone

    630 555 6594

    Email

    blank

    Company

    Azalea Mfg

    Street Address

    951 Flora Way

    City

    Fauna

    State or Province

    MI

    Zip code

    65318

    Country

    US

    Send replacement parts to:

    Customer Address

    Parts Details

    

    Material:   

    Batch Number: 

    Qty:

    Issue Code: 

    24151-902 CPX200 RealWaxTM Material 24151-902 CPX200 RealWaxTM Material 24151-902 CPX200 RealWaxTM Material 24151-902 CPX200 RealWaxTM Material 24180-902 S200 Support Material

    XW111612B XW132106B XW111403B XW130804B SW140303F

    2 2 1 1 3

    LPE - leaky plunger end LPE - leaky plunger end LPE - leaky plunger end LPE - leaky plunger end LPE - leaky plunger end








    Thursday, December 4, 2014 7:15 PM

All replies