G
Guest
I have a linked table to an Outlook inbox. The subject of the e-mail
messages is a memo. My problem is that I need to "read" the memo and find
data on certain lines.
The memo will look something like this
Order: J123451
Placed By: Joe.systems,daily
Order: J123452
Placed By: John.systems,daily
Order: J123453
Placed By: Tom.engineering,daily
Order: J123454
Placed By: Joe.systems,weekly
I need to find each order number and create a Orders record (J12345) in the
Orders table and write the detail to a OrdersDetail table that has a "lookup
field" to the Orders Table.
How do I go about this?
messages is a memo. My problem is that I need to "read" the memo and find
data on certain lines.
The memo will look something like this
Order: J123451
Placed By: Joe.systems,daily
Order: J123452
Placed By: John.systems,daily
Order: J123453
Placed By: Tom.engineering,daily
Order: J123454
Placed By: Joe.systems,weekly
I need to find each order number and create a Orders record (J12345) in the
Orders table and write the detail to a OrdersDetail table that has a "lookup
field" to the Orders Table.
How do I go about this?