Tab delimited info from e-mail body to Access Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Byrd - 29 Sep 2005 20:28 GMT

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.

Signature

Jeff Byrd

Reply to this Message

Eric Legault [MVP - Outlook] - 05 Oct 2005 20:49 GMT

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?

Signature

Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

> 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.
[quoted text clipped - 5 lines]
> 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.

Reply to this Message