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


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