Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Tab delimited info from e-mail body to Access Database

12 views
Skip to first unread message

Jeff Byrd

unread,
Sep 29, 2005, 3:28:32 PM9/29/05
to
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.

--
Jeff Byrd


Eric Legault [MVP - Outlook]

unread,
Oct 5, 2005, 3:49:11 PM10/5/05
to
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?

--
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/

Timothy

unread,
Sep 5, 2017, 12:42:28 PM9/5/17
to
Hi,

I am regularly (daily) receiving mails from a employee about attendance of 250 employees in mail body pasted as table.

I want to extract it to excel file.

What would be the macro for this.

The mail start like this

Dear Sir,

Kindly find the attendance for 5-Sep-17

Then table with employee id, name, in time, out time

Diplodok

unread,
Sep 6, 2017, 4:34:42 PM9/6/17
to
Hi.
Could you send and example of such email to address:
dr_avk(at)mail.ru
Yours, Andrey

0 new messages