If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
extract pieces of data from 1 field (subject line)
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access & OleDb - generating schema changes, problem with identity/counter fields. | Thomas Tomiczek [MVP] | Database Design | 9 | November 5th, 2004 10:32 AM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
How to extract original data from a pivot table? | cmagnus98 | General Discussion | 1 | July 9th, 2004 03:55 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |