PDA

View Full Version : Import body of outlook email into a table



jmentor
09-02-2007, 04:12 AM
I have the following text contained in the body of an email which I need to import into an access table.
Here is the csv text


LENOV ,10/07/2007,RF2966,739739,"1427-6234
62345",01,25,0,10/07/2007
LENOV ,10/07/2007,RF2966,739740,"1427-6234
62346",01,14,0,10/07/2007
LENOV ,10/07/2007,RF2966,739741,"1427-6234
62347",01,19,0,10/07/2007
LENOV ,10/07/2007,RF2966,739742,"1427-6234
62348",01,12,0,10/07/2007

Can you please help me get these fields into an access table.
The email client is Outllook
Thanks in advance

OBP
09-02-2007, 10:34 AM
Import the data in to a Memo field and then use VBA to split it in to fields.

jmentor
09-02-2007, 11:11 AM
Thank you for your reply.
Could you tell me what code to use to extract
the info from outlook and then to place it in a memo
field. I can then split it up as you suggest

Thank you