I'd use the same text parsing functions, Instr() and Mid(). Use Instr() to
search for the text "Email Address", then from that starting position,
search for the text "A:", etc. Use Mid() to clip the text.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GregoryL.[AITI]" wrote in message
...
Thanks Sue for the pointers and links, I'm almost there!

The example at
http://www.outlookcode.com/threads.a...&messageid=696 is very
close
to what I'm dealing with except the data value attached to each label is
on
the line below it - see example...

snip
Q. Email Address
A.

Q. First Name
A. John

Q. Coffee Type
A. Arabica
snip

I can successfully locate & return the Email Address label, how do I go
the
next step and get the code to locate the label but return the line below
it
for trimming and insertion into my reply email?

TIA -Greg

"Sue Mosher [MVP]" wrote:

You might find this code sample useful:
http://www.outlookcode.com/codedetail.aspx?id=89 It shows how to parse a
structured text block as your scenario describes.

"GregoryL.[AITI]" wrote in
message ...
Hi everyone,

I receive a lot of plain text emails that contain data in a preset
format
that I would like to auto reply with a custom form I have built. I
would
like
to know if I can locate and use certain values from the original
message
in
my reply (e.g. original msg contains as plain text First Name: John and
Coffee Type: Arabica. Can I locate John and Arabica in the original msg
and
populate those values in my auto reply form - Hi John, thanks for your
enquiry about our Arabica coffee range...)

It seems straight forward enough yet any help or pointers in the right
direction would be greatly appreciated.


TIA

Greg