Outlook data from emails into Excel Spreadsheet

[ncopeman]

Hi all, i'm new to this forum, brought here by countless hours of research and came across this post here... (which looks similar)

I run a website and opened a competition, using an email form with specific fields to fill in (First name, Surname, email address, Competition answer dropdown, tickbox for newsletter).

I need to create a macro to extract this data from the emails i've received (over 700 so far) and add them into an excel spreadsheet. This is so I can remove duplicate entries, select a winner - and for those wanting to subscribe to the newsletter - add their email addresses to mailchimp.

The emails I receive come in like like this:

[Where are our products made? ] Wales
[First Name] Joe
[Surname] Bloggs
joe@bloggs.com
[I would like to receive further mailings & offers with details about competitions, exclusive offers & news.] Yes
[I have read and accept the Competition Terms & Conditions] Yes


Our Website - (website URL to competition is here)
Client: 94.22.133.172 - Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
[/QUOTE]

I don't need the website link or client IP - Just the fields in [ ] exported as a spreadsheet .... I won't be running the macro until the competition is closed - so it will only be run once.

If someone could put me out of my misery i'd be greatly appreciative. It's driving me up the wall!

On another note, I ran a BBC website in which we asked for submissions using a webform, one of our techie guys created a Macro for me and exported the info in a spreadsheet and as an XML for our Content Management System... Alas both the techie guy and myself have now left the Beeb and i've lost contact with him...

This maybe my last hope. Thank you all for your time.

Neil

 

[shawnhet]

I don't have time to do this through VBA but if you like you can save all these emails to a merged text file and then export or copy that data into Excel. Once that is done, it should be pretty easy to get it into the format you are looking for.

Here is some instruction for Saving emails to a text file:How to Save Messages as Plain Text with Outlook - About Email

Why don't you try that and then get back to us with a sanitized sample of the data (a couple of examples would be good).

Cheers,