
Signature
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.
> Can you explain what you mean by ""emergency contacts"?
>
[quoted text clipped - 5 lines]
> > 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?
Judy Gleeson [MVP Outlook] - 28 Jul 2006 00:23 GMT
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.

Signature
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
[quoted text clipped - 31 lines]
>> > so
>> > that you can link the fields to an Access database?
Judy Gleeson [MVP Outlook] - 28 Jul 2006 02:55 GMT
I found this today too....
http://blogs.msdn.com/roberdan/archive/2004/09/02/224897.aspx

Signature
Judy Gleeson, Microsoft Most Valuable Professional, Outlook
Director, Acorn Training and Consulting
Author - Productiv_IT with Outlook
www.acorntraining.com.au
> You're wrong about Outlook only printing in alphabetical order. ""reason
> they have to be in
[quoted text clipped - 50 lines]
>>> > so
>>> > that you can link the fields to an Access database?