Email import into Excel

[vcellier]

Hi,

After searching the web and this forum for a while, I don't seem to be able to find a solution.

Our customers fill our a form on our website and I receive these filled out forms by email. I receive one email per form filled out.

They look like that:

DATE SUBMITTED: 12/04/2010 3:04:38 PM

NAME: xxx
PREFERRED METHOD OF CONTACT: Email
ADDRESS: xxx
CITY: xxx
STATE: xxx
COUNTRY:
POST CODE: xxxx
PHONE: xxxx
FAX: xxxx
EMAIL: xxx@xxx.com

I AM A: xxx

I WOULD LIKE INFORMATION FOR: xxx

POSTCODE FOR NEAREST STOCKIST: xxx

DETAILS OF ENQUIRY: xxx

WHERE DID YOU HEAR ABOUT US: xxx

I need to import some of this data into excel and displayed like follow:

A1: I AM A
B1: PREFERRED METHOD OF CONTACT
C1: STATE
D1: WHERE DID YOU HEAR ABOUT US
A2: XXX
B2: XXX
C2: XXX
D2: XXX

So the first row would be the column headings and the following rows would be each details from each email.

Any help? Is it even possible?

[xenixman]

Try this:
It’s a bit involved, but what your are going to do is first separate the data into two columns, with the help of the colons in your emails, then transpose the data from rows to columns.


Copy complete e-mail

Open Excel,
Place your cursor in cell A1

On the Task Bar,
Edit
Paste Special
Paste as TEXT
Click OK
On the Task Bar,
Data,
Text to Columns
Select Delimited,
Click Next
Tick Other, and in the small box enter a colon ( : )
Click Next
Click Finish

Your data should now be in two colomns, A & B

Next
Highlight Cells A1 through B20, your complete email

On the Task Bar,
Edit,
Copy,

Move your cursor to cell C1

On the Task Bar,
Edit
Paste Special,
At the bottom tick TRANSPOSE
Click OK,

Your data should now be in the Column format you want.