Extracting Parsed emails in Access...

[ID10Terror]

Hi:

I have created a web page that thru CGI is sending parsed information to my
email account. In Access, I retrieve those emails. My problem is that the
field contains dozens of parsed/paired lines. Is there a way to extract
those lines individually and append them into a new table? For what it is
worth, the table is tblReceive, field is fldContent (memo).


Idiot Error (ID 10 Terror)

 

[John Nurick]

Hi,

Basically there are two ways to go. One is to write code in your
favourite language to munge the contents of the emails into a text file
that Access can import. The other is to write Access VBA code that reads
the emails, extracts the data you're interested in, and appends it to
your table.