Hi - Brand new here and thirsty to learn.

I receive system generated emails. I want to parse some of the fields from the body of the emails into my access tables (The outlook folder is linked up and ready to go!). I need help creating the expressions in my query to only grab the information (no matter how long or short) I want and nothing else. For example:

Member #(always 10 digits)

Referred by: (someone's name which could be very long or short)

Member Name: (again long or short OR A BUISNESS)


Help, please?