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.

Am Wed, 10 May 2006 05:48:02 -0700 schrieb LDMueller:

A good point to start at is: http://www.outlookcode.com/d/database.htm

There look for Connectionstring and Recordset to open a connection to the
database and write into it.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


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.

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


"LDMueller" wrote:

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.

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.

"GaryA" wrote:

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


"LDMueller" wrote:

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.

Too funny...that is exactly what I ended up doing for now!

"Michael Bauer" wrote:

Am Wed, 10 May 2006 05:48:02 -0700 schrieb LDMueller:

A good point to start at is: http://www.outlookcode.com/d/database.htm

There look for Connectionstring and Recordset to open a connection to the
database and write into it.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


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.