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.

"Judy Gleeson [MVP Outlook]" wrote:

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


"Musicman" wrote in message
...
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?