Programmatically Export Outlook Mail to Microsoft Access

L

LDMueller

I need to be able to open an email in Outlook 2003 and then click a button on
the toolbar which will move this message to a MS Access 2003 database. I
assume I'll need to right some sort of VBA code in Outlook 2003 which I can
link to my toolbar button, but I really don't know if my logic is correct on
what I need to do and I don't know how to begin.

I've done a lot of research, but I just can't seem to find what I need as
far as writing the VBA code to send the email to Access. I did open my
Access database and linked a table to Outlook. This works fine, but I need
my users to be able to be in Outlook and then send the email over to Access
for further manipulation.

Any assistance would be greatly appreciated.
 
G

GaryA

Hello...I am looking for something similar to handle support issues that we
get via email. Were you able to find a solution to the button in the message
tool bar? GaryA
 
L

LDMueller

No, I ended up creating a linked table in Access to an Outlook folder. Then
I created an Append query to append the data to another table, and a Delete
query to delete the contents of the Outlook folder once it was in the
database.

Currently, I'm having my users move or copy the email they want in the
database into this folder.
 
Top