What i am doing is such...
I have a linked table to an Outlook Folder, and when an email comes in, i would like to generate a new "Client Record". I can easily grab the email address, sent time, and all that, but the body of the message contains one string that has a bunch of Info...
Name: Adam Roof
Address: PO Box 1234
City: My Town
State: CA
Interest: Network Wiring
Source: WWW
That is a sample of my website Form Post that emails me.
I see how i can grab the data now, thanks to all of your posts.
MY OTHER question, is can this happen as soon as a new email comes in??
rst!Name = Mid(me.emailBody,InStr(me.emailBody,"Name:")+5, (InStr(me.emailBody,";")-InStr(me.emailBody,"Name:")+5)-1)
rst!Address = Mid(me.emailBody,InStr(me.emailBody,"Address:")+8, (InStr(me.emailBody,";")-InStr(me.emailBody,"Address:")+8)-1)...etc