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


"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?

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?

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?

I found this today too....

http://blogs.msdn.com/roberdan/archi...02/224897.aspx

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

www.acorntraining.com.au


"Judy Gleeson [MVP Outlook]" wrote in message
...
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?