extracting text from gmail into excel

[soundfever]

hey guys, I hope to get help here, as my knowledge about excel is very minimal.
I have a webbased system (created by my webmaster), which creates an email everytime client submit order.
I wish to get access to text/data within email, to import them automatically into excel.
here is a copy of email/document :

MASTERING ORDER SUMMARY
Job Order Number: xxxxx
Delivery Date: 7 Feb 2014
Price: £xxx

ORDER DETAILS
Number of Songs: 1
Type of Release: Single
Medium: Digital
Song Title(s):
XXXXX
Alternative Upload Selected? No
Uploaded File: No file
Expected Level of Mix Processing: Noticeable
Loudness Level: Loud
Mix Review: 0
Stem Mastering: 0
Extra Loud Master: 0
Non Standard File Format: 0
Red Book / DDP: No
Songs Over 5 Minutes: 0
Additional Notes:
None

CLIENT INFO
Artist / Group Name: xxxxxxx
Genre: xxx
Website: www.xxxxxx
Contact Person: xxxxxx
Contact Person Role: Producer
Contact E-mail Address: xxxxxx
Permission to use 90 sec as a sample for promotional purposes? Yes
How did you find us?
_________________________________________________________________________________________________

thank you in advance

 

[soundfever]

anyone able to help?

 

[perimidt]

Hi

I wouldn't know how to excatly, but I think you need to clarify a couple of things.
Do you open the e-mail on the web? Or can you access it with Outlook?

And is there any change your webmaster can attach the data in a text or csv-file instead?

With both Outlook and a csv-file I believe this should be doable with vba from Outlook.

If not I think it's gonna be really difficult to get it into Excel any quicker than just copy and pasting it.