Copying data from Outlook mail message to an Access database? 2

[jscter2]

Folks

What i'm trying to do is basically the following.

I have a access database for logging tasks whick are supplied to me in an email. What i normally do is copy and paste the from, to,subject,main body text fields in to this database. What i want to do is find a way of placing a button on outlook that when pressed will copy all this information from the current message window in outlook into a new record in the database. Any ideas?

cheers
John

 

[nberryman]

I can't remember exactly but try searching Microsoft Knowledge base for

How to Programmatically populate access from Outlook.

I am sure there is an example there

Sorry I can't be more specific Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[lynnvictoria]

IF you will go to this website, there is code there for simple importing and exporting Access/Outlook and Outlook/Access, it does take some work and programming. Hope this helps.

http://www.helenfeddema.com