J
Jack
I have a linked table to a outlook inbox. I am trying to build query based on
the information inside these emails. These are customer orders that have been
been submited via frontpage form and then emailed via pop3 acct. I need to
not only extract data from the subject line but also from the body. I would
like to have this info placed in new table. Below is a example.
Subject:
websitename - typeofserviceneeded - Countyserviceneeded - Stateserviceneeded.
Then in the body of email I have:
Customerfirstname: xxxx
Customerlastname: xxxx
Address: xxx
Etc etc.
basically I would like to place 'these emails' in table but do query based
on website, county , state.
From some of the posats I have read I believe I will need to use a InStrRev
statment. Any assitance would be greatly appreciated.
Jack
the information inside these emails. These are customer orders that have been
been submited via frontpage form and then emailed via pop3 acct. I need to
not only extract data from the subject line but also from the body. I would
like to have this info placed in new table. Below is a example.
Subject:
websitename - typeofserviceneeded - Countyserviceneeded - Stateserviceneeded.
Then in the body of email I have:
Customerfirstname: xxxx
Customerlastname: xxxx
Address: xxx
Etc etc.
basically I would like to place 'these emails' in table but do query based
on website, county , state.
From some of the posats I have read I believe I will need to use a InStrRev
statment. Any assitance would be greatly appreciated.
Jack