none
VBA Code for transferring data from email in Outlook to a spreadsheet in Excel RRS feed

  • Question

  • I'm not computer savvy, and I've been here before for help with a similar issue. Please, see the info below and help me if you can... Thanks!


    I have client emails being sent to my Outlook as follows:

    Ship Date: 07/01/2012

     

    CONTACT INFORMATION

     

    Name: BLAH

     

    Email Address: BLAH@BLAH.COM

     

    Phone: 9999999999

     

    VEHICLE INFORMATION

     

    Year: 2008

     

    Make: Honda

     

    Model: Civic

     

     

    PICKUP AND DELIVERY INFORMATION

     

    Pickup City: EDISON

     

    Pickup State: NJ

     

    Pickup Zipcode: 08837

     

    Delivery City: NOVATO

     

    Delivery State: CA

     

    Delivery Zipcode: 90009

    The thing is, I only need a few of the items to be parsed over to my Excel worksheet. I have to keep all the information organized in columns, and I eliminated the information I don't need parsed. I have also changed the names to match what the name of the columns are in Excel:

    Name: BLAH

     

    Email Address: BLAH@BLAH.COM

     

    Phone: 9999999999

     

    Year: 2008

     

    Make: Honda

     

    Model: Civic

     

    P:Zip: 08837

     

    D:Zip: 90009

    If someone can just make a code I can copy and paste into my VBA on Outlook, I would really appreciate it... I don't know how to do anything more than create a new VBA. THANKS!!!!!

    • Moved by Reed KimbleMVP Tuesday, June 19, 2012 10:57 PM VBA question (From:Visual Basic General)
    Tuesday, June 19, 2012 9:27 PM

All replies