automate access2000 form; patient name,date,time of appointment

[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

 

[Sandra Daigle]

Sure, take a look at the following articles for some ideas on how to get
started:

Outlook for the Summer
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office071299.asp

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm