Set outlook Appointments in Access database

[Guest]

I have a simple contact mangement database in Access 2003. I use Outlook to
manage my calander. I would like to be able to set outlook appointments
directly from the database, so as I log follow up calls with customers I can
schedule their appointments and all the info I already typed for the call
will show up. Right now I am putting things in twice. Is there any way to do
this?

 

[Mike Labosh]

I have a simple contact mangement database in Access 2003. I use Outlook to
manage my calander. I would like to be able to set outlook appointments
directly from the database, so as I log follow up calls with customers I
can
schedule their appointments and all the info I already typed for the call
will show up. Right now I am putting things in twice. Is there any way to
do
this?

Inside your Access application, you will need to set a reference to the
Microsoft Outlook Object Library in your VBA window.

Then you will need to write code that creates an instance of an
Outlook.Appointment object and set its properties as appropriate. After
saving it, it will appear in the Outlook calendar.

There are lots of other details though, so if you get stuck, post back.

--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei


news:[email protected]...