Thursday, 5 September 2013

Importing Data from Outlook 2010 into Excel 2010

Importing Data from Outlook 2010 into Excel 2010

I have form on my website which gets emailed when the customer completes
it, then looks like this:-
You got mail from Mr Kelley McIntyre.
Here is the form data:
First Name : Mr XXXXX
Last Name : XXXXXX
Company Name : Army
Email Address : XXXX@hotmail.co.uk
Telephone/Mobile No : 0123456789
Date of Event : 14/12/2013
Number of Guests : 80
Budget : 6500-7000
Type of Event : Other
Catering Required : Yes
Drinks and Entertainment Requirements : christmas meal, welcome drink,
wine at table
British Army Warrant Officers & Sergeants plus wives and partners
How Did You Hear About Us? : GoogleAs you can see its fairly simple
form, however I need to export this data into Excel every time I get one
of these emails, so I can keep a record of all the enquiries we get.
Can someone help? I know how to do a Macro, but if its VBA, then I'm lost,
so its needs to be in idiot format if possible!

No comments:

Post a Comment