Parsing Email form data and entering to excel cells

Hi all

I have untidily stitched 2 pieces of code together: the 1st taken from elsewhere in this forum (the idea of including a button is exactly how i want to use this code - have the button set up already); the second is taken from a Sue Mosher piece about Parsing text.

Put simply I want to process an 'enquiry form' email after I have read it by clicking a button which copies name and address details etc over to specified excel workbook cells (which are key to further processes in my CRM).

Here is the form I receive:

name: Sammy Snake
address: Serpent Wynd
town: Adder Water
postcode: SN4 4ES
email: [email protected]
phone: 00000000000
heardfrom: Homes and Interiors Scotland
HTTP User Agent: Mozilla/5.0 (Windows NT 6.0; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
Date: 18 June 2011
Time: 13:18

furthercomments:

Hello ssssssssonny


Here is the code I have: it throws up a "Compile Error: ByRef argument type mismatch" @

strBody = out_mail.body

strName = ParseTextLinePair(strBody, "name: ")

this is the code where I need to mesh the two elements together to work in tandem.

Please Login or Register  to view this content.

Clearly I am no expert and there may be serious and obvious errors that I am otherwise unaware of but any advice will be very warmly received!

Can any of the experts here offer some help? That's why I came here!!

Any ideas as to how I can make this work; or does anyone know if it can even be done?

Please help!

or am I trying to fit a square peg in a round hole here?