automate access2000 form ,patient name,date,time to outlook calendar then e-mail

[Keith]

Hello,

We have several clinics and we take patient appointments
from a central location. I have created a access2000
database with
a main form and users input the patient appoint date and
time in one section of it. There is a hyperlink button to
bringup that clinics shared outlook calender and then
users update the appointment with patients
name,appointment date and time there as well, then they
forward the appointment from calendar as e-mail to the
clinic notify them. Can I automate this? can from the
date and time of the appointment on the main form create
a button that will input date and time into the correct
clinic calendar,correct date and time and send e-mail
automatically? This can really cut down the amount of
time and steps we now must do..

Thank you,
Keith Bemis

 

[Marc]

We have several clinics and we take patient appointments
from a central location. I have created a access2000
database with
a main form and users input the patient appoint date and
time in one section of it. There is a hyperlink button to
bringup that clinics shared outlook calender and then
users update the appointment with patients
name,appointment date and time there as well, then they
forward the appointment from calendar as e-mail to the
clinic notify them. Can I automate this? can from the
date and time of the appointment on the main form create
a button that will input date and time into the correct
clinic calendar,correct date and time and send e-mail
automatically? This can really cut down the amount of
time and steps we now must do..

Hi Keith
Yes it can be
automated.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/d
no2k3ta/html/odc_ac_olauto.asp

http://msdn.microsoft.com/library/d...deopg/html/deovrunderstandingvbainoutlook.asp
Marc