Getting records from a Memo

H

Helgard

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scanning Through "Memo" Field Is Very Slow 5
VBA line feeds in memo field 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
I'm new to this - how do I add record 3
Access Memo Field to WORD Doc 1
Automatic record generation 2
Populating memo field by clicking command button 2
nk into onenote 2016 paragraph from excel 2016 cell 0

Top