View Single Post
  #6  
Old February 6th 07, 06:49 AM posted to microsoft.public.outlook.contacts
Judy Gleeson \(MVP Outlook\)
external usenet poster
 
Posts: 1,046
Default merge Word & Access & Outlook

Report like functions is Outlook are actually Views. They can be filtered
and you can make views on her PC that are easy for her to use.

1. Try out making a New Field (turn on the Advanced Toolbar and use the
Field Chooser) for YES/NO Christmas Card.

2. Have a play around with the Define View function in the Contacts folder.
It's easily accessible from the Current View window on the Advanced Toolbar.
For example you can show (and print) only the YES entries, or only Category
= friend.

3. What you see on screen is what you get when you print from Contacts.
Play with Print Preview.

I think you may well be fine with Outlook. Especially as that's what she's
comfortable with.

I hope this helps you at least a little bit!

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

Imagine if every Thursday your shoes exploded if you tied them the usual
way. This happens to us all the time with computers, and nobody thinks of
complaining.
Jef Raskin, interviewed in Doctor Dobb's Journal
"Caryl" wrote in message
...
I must admit - I'm cannot foresee everything that will all be needed but
here
is best I can do: This is a job that my boss assigned to me, for his
mother, because I am the only one in the office that has much Access
knowledge.
Currently - I have her Christmas card "list" in Access & am able to print
envelopes & labels. Right now, there is a Word document with a list of
her
frequently called #'s that she has posted near her phone. Mom recently
got
a laptop computer & she has been using Outlook to email her friends. She
has
saved these email addresses in Outlook.
Presumably many of these name overlap.

The original assignment from my boss was to put ALL of her "contacts"
into
an Access data base combined with her Christmas card list.

I think it would be best to eliminate as many of the "double entries" as
possible.

My thought is: format the Word document so that I can export it to
Outlook
&/or Access . That gets rid of one of the "double" entries. That leaves
me
with: Can Outlook print out a report of names to post near her phone? &
quite possibly print a Birthday List? If Outlook can handle that, then
most
of the hurdles are jumped & I need go no further. I am new to Outlook but
do
not believe that it has "report" like features. So -
I know Access can do these reports. so I'm thinking that I can enter all
names into Access & export to Outlook. BUT
if she makes an e mail address change in Outlook (the only one she is a
little bit comfortable with), then that leaves me with obsolete
information
in Access. So THEN I need to find out IF ( & how) I can link Outlook to
Access.
So - I'd love to have you answer all of the above, But at the very least
can
you confirm that Outlook does or does not have any "report" like features.
Sorry so long - thanks for your time & will appreciate any/all answers you
can provide.



Ads