I have messages sent to me from a company in a standard format.

The message has fields and data from a form and therefore is in the same
location each time.

When a new message arrives, I'd like to read the message text and then
extract certain data (i.e. email address, First Name, Last Name, etc).

Using these fields, I'd like to send a response inserting the above
extracted data into the message.

What is the best way to do this?

If macros are the way to go, is there sample code to do this?

Thanks,

MEG