Results 1 to 2 of 2
2005-06-29, 06:53 #1
- Join Date
- Mar 2004
- Thanked 0 Times in 0 Posts
Importing information from outlook to Access (2000)
Is is possible to automatically import information from an email into an access database?
I would like to import the following information which was sent to me in an amail.
The fields l would like to import are as follows:
I would like to extract this information and place it into the database.
Is this possible?
see below for details to be imported.
Qty 1 Compaq EVO Laptop Computer, Serial No. N610cP180X430VC252
Qty 1 Carry Case
Qty 1 AC Adapter, Serial No. 2Y11423404
Qty 1 Modem Cable, Part No. 112666-008
6 x CD Software Bundle Comprising:
Compaq QuickRestore Application Recovery CD
Compaq QuickRestore System Recovery CD (1 of 2)
Compaq QuickRestore System Recovery CD (2 of 2)
Easy CD Creator 5.31 Basic
InterVideo Win DVD
2005-06-29, 07:00 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Importing information from outlook to Access (2000)
You can use Automation to control Outlook from Access. If you do a search for Outlook.Application in this forum, you'll find several examples and links.
The major task would be to parse the text in the body of the e-mail into individual fields. Since the items seem to have different formats, that won't be easy.