Hi All,

In the company I work for I'm having an issue with linking into
Outlooks2007 global address list using Access2003. At first after
linking to the GAL and opened the table I was seeing the x400 style
email address instead of the SMTP style no matter which address book I
linked to I got the x400 style and now when I try to open the linked
table Access2003 crashes.
I called the help desk here and they did not know/understand what I
was talking about and so they could not help unless I could give them
MORE information.

has anyone run into this before?

can anyone explain what is going on?

Is it an Access2003 issue or an Outlook2007 issue?

how do I get the SMTP style email address to be displayed instead of
the x400 style?

note: I've cross posted this in the Outlook forum as well

thanks
bobh.

On Apr 12, 1:57*pm, bobh <vulca... (AT) yahoo (DOT) com> wrote:
If the Email Address field in the table...and if it ended with
something like /cn=ABC....Is ABC the email address without the
domain? The next field over is Account. Are the values for Account
the email address without the domain?

On Apr 12, 6:24*pm, Patrick Finucane <patrickfinucan... (AT) gmail (DOT) com>
wrote:
the x400 style looks like this --> /O=MCCM/OU=MEM/cn=Recipients/
cn=HynesB

and no the /cn=HynesB is not the email address minus the domain name
and nether is the Account field
bobh.

On Apr 13, 10:55*am, bobh <vulca... (AT) yahoo (DOT) com> wrote:

This from the following link http://www.alvestrand.no/x400/faq-mhsnews.html

---------
If you have an Internet address of the form username (AT) domain (DOT) name,
there are two alternatives for your X.400 address:
EITHER there is a defined mapping onto standard attributes for your
domain, so that, for instance

Harald.Alvestrand (AT) delab (DOT) sintef.no

maps to

C=no;ADMD= ;PRMD=uninett;O=sintef;OU=delab;S=Alvestrand;G=Har ald

-----------


OK, In the above ex there's G & S that make up the name. The domain
is the OU + O + C. So Bob, you gave the example of /O=MCCM/OU=MEM/
cn=Recipients/cn=HynesB

Using the above would the email addy be HynesB (AT) MCCMMEM (DOT) com...or
anything close to that?

You posed an interesting question. One (me) wonders why MS couldn't
have added a column that was the regular email format most are used to
when linking to Outlook files.

Another example of a missing part is a method to show attachments if
one imported the Inbox into Access. You get some information...just
not all...like the attachments associated with the email. Good
concept, just not fully implemented by MS for any practical use by a
programmer.

It's possible you will get better results from writiing an Automation
routine rather than an incomplete implementation by MS.

One thought. That's an address by the author. Maybe send him a
question. The worst that can happen is that he ignores your email.