+ Reply to Thread
Results 1 to 3 of 3

import MS Outlook body into Excel

  1. #1
    Registered User
    Join Date
    05-09-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    3

    import MS Outlook body into Excel

    Hi guys. Here is my problem that I can not seem to be able to figure out myself and I've spent hours trying to and endless hours searching for an answer on Google. I have a form that people fill out, when they hit submit I get an e-mail with all of the information I requested. The e-mail looks like the screen shot in the attached picture. What I would love to do is to some how get that information into excel so that I can then use it to sort it and do all kinds of stuff with the filled out form. I know how to do all that, what I am having trouble with is getting this information into Excel in a way that is USABLE.

    I do knot how to get the "body" (.body) of an outlook e-mail into excel, but all that does is paste everything from the body into a single cell, thus making it useless for me. it's got bunch of weird symbols, etc.

    What would work is for me to be able to do "CTRL + A", "CTRL+C" inside the Outlook body so that I copy all of the text, then paste it into excel. This will paste the e-mail nicely and I'll be able to find all of the fields...for instance "first_name" will be in B30, and the actual name of the person will be in C31. So then I could easily read the form and pull out any information that I need.

    Is this possible? I know it is possible to use SELECT ALL, then COPY then PASTE into excel when playing with Internet Explorer in VBA. But I've never done it with Outlook. If anyone has even a better way of getting that table/of whole body into an Excel spreadsheet, please, please help me out!

    Thank you all!!
    Attached Images Attached Images
    Last edited by wfdude; 05-09-2011 at 09:11 PM.

  2. #2
    Registered User
    Join Date
    05-09-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: import MS Outlook body into Excel

    Anyone? Please guys, I'm stuck with this and I can't proceed onto other things until I solve this....and I don't have the brains to do it! :/

  3. #3
    Registered User
    Join Date
    05-09-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: import MS Outlook body into Excel

    guys, anyone? sorry to bump this but i need to give it another shot as i can't figure this out on my own and google has been useless thus far!

+ 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