Tab delimited info from e-mail body to Access Database

  • Thread starter Thread starter Jeff Byrd
  • Start date Start date
J

Jeff Byrd

I need to move tab delimited data from the body of an e-mail to a table in
an Access database. The data is in text form and consists of 6 fields.

I am using Oulook 2003 attached to Exchange 2003 and Access 2003.

I thnk it would be best to do it from a VBA Script in Outlook.

Can this be done would it be better to recieve the data as an attachment.
It come one record at a time from a feedback form on our web site.
 
Sure, this can be done. You just have to parse out the contents of the
MailItem.Body property so that you can insert it into your database. There's
nothing that the Outlook Object Model can help you with here though. You'd
need to use VB/VBA string functions to parse the text, and the Access Object
Model or DAO/ADO to write the information to the database.

Is there something in particular that you are having difficulties with?
 
Back
Top