Macro or routine required

[evanhughes]

Hi All

I'm new to this site so please bear with me.



We recieve a daily influx of emails from links on our website with prospective client leads.
What I would like is a macro or routine that I can run when I open these emails and have the information extracted and copied to an access db table or an excel spreadsheet.
The table or spreadsheet will have the same column/field names as are on the email.

Name :
Email :
Tel :
Address :


Referral :
Development :

Message :

I have attached a screenshot of a recieved email.

Is this possible.

Regards

Evan