Seting up Emergency Contacts.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is a good way to set up emergency contacts in Outlook and have it so
that you can link the fields to an Access database?
 
Can you explain what you mean by ""emergency contacts"?

What version of Outlook?

Why do you want them in Access? What are you trying to achieve?
"

--
Judy Gleeson, Microsoft Most Valuable Professional, Outlook
Director, Acorn Training and Consulting
Author - Productiv_IT with Outlook

www.acorntraining.com.au
 
Someone we can call in case there is an emergency. The fields would be
emergency_contact_1, emergency_phone_1, etc. The reason they have to be in
Access is order to have control over how the lists will be printed off. The
lists are organinzed by unit hierarchy and location, not by alphebetical
order. For instance, supervisors, reception, ect. ect. Outlook only prints in
alphabetical order: ascending and descending. I could type it out everyweek,
but that's very time consuming. What I want is this. The contacts are linked
to a data base in Access. The positions are linked to another table that has
a primary key for how they are organized in the report. The report
automatically organizes the contacts into a structured report by unit
hierarachy and locations. It's complex I know, and maybe out of the leauge of
what office is able to do. However, this is a non-profit and we have limited
software. Oh, and the reason I don't enter them into Access myself is becuase
other users will be modifying the contacts in Outlook because we have a
shared folder. However, our IT department is unwilling to set up a shared
drive for us so that we can share the Access file.
 
You're wrong about Outlook only printing in alphabetical order. ""reason
they have to be in
Access is order to have control over how the lists will be printed off. The
lists are organinzed by unit hierarchy and location"" if that's really the
only reason to put them in Access - it's your lucky day!!!!!!!!!

Have a good play with Define New View function in the Contacts folder. Turn
on the Advanced Toolbar and use the Field Chooser. I will assume v2003 as
you have not stated your version.

You can make filtered views and print these. So I could make a View of just
the receptionists and print it. You can select whatever data fields/columns
you want in the printout - it's just a flat database.

If that won't do it for you, you may need to go to the Access group for more
help.

--
Judy Gleeson, Microsoft Most Valuable Professional, Outlook
Director, Acorn Training and Consulting
Author - Productiv_IT with Outlook

www.acorntraining.com.au
 
Back
Top