Import Into Access from GAL show Duplicate Names

[Robert T]

Hello:

I work at a government agency where we have approximately 4,500 employees
and other assorted info stored in Outlook 2003. I used Access 2003, via the
Exchange function, to import the GAL for our student class registration
database. I found well over 100 employees who had at least 2 or even 3
entries in our imported Access table. However, when you go back into Outlook
2003, those very same employees are only listed once.

In addition, I was told that I found employees who no longer work at the
agency, and if you go into Outlook, click on the TO tab, they are no longer
listed.

So that brings me to my question. If all of these people show up only once
if you click on the TO tab, or not all, where did Access 2003 find all of
those duplicate entries and/or people who no longer work at the agency. I
hope you have a good answer because the manager in charge of Outlook is not
happy with my discovery.

Thanks,
Robert

 

[Francine Otterson]

The Exchange Administrator may have disabled and/or hidden the account which
means you would not see it in the GAL or by clicking on the TO. However
since the record is actually there I am assuming it would still be imported.
As for the duplicates - I would confirm that was indeed only one record on
the Exchange and if there was not an issue with the import into Access.

Want function is the function you used in Exchange. If actually done within
Exchange this may be a more suited question for the Exchange Newsgroup.l

Best Regards,

 

[Robert T]

Hi Francine:

Thanks for the prompt response. What do you mean by the WANT function? How
and why would I access that function in Outlook?

Is there an Exchange Newsgroup? I can't seem to find it.

I did some additional research and many of the duplicate names seem to be a
result of having a PAGER number. I don't know why that would make a name come
up twice in an import.

Thanks,
Robert

 

[Brian Tillman]

Is there an Exchange Newsgroup? I can't seem to find it.

microsoft.public.exchange.admin