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!!![]()
Bookmarks