Accessing Outlook 97 personal address book

[someone]

Hi,

I currently have an Access 97 database that includes a field for
contact name of a user. This user will almost always have a valid
email address contained in the personal address book of the person who
inputs the records into the database.

At present the person inputting the records has to manually look up
the correct address and copy in into the field. I know that it should
be possible to lookup that address by some form of automation but I
can't find any pointers anywhere.

Any help or advice on this would be most appreciated.

TIA

Tony W

[Pieter Linden]

so*****@home.co m wrote in message news:<cm******* *************** **********@4ax. com>...

Hi,

I currently have an Access 97 database that includes a field for
contact name of a user. This user will almost always have a valid
email address contained in the personal address book of the person who
inputs the records into the database.

At present the person inputting the records has to manually look up
the correct address and copy in into the field. I know that it should
be possible to lookup that address by some form of automation but I
can't find any pointers anywhere.

Any help or advice on this would be most appreciated.

TIA

Tony W

How about creating a linked table? link to Outlook, then choose
AddressBook or whatever, and then you can query it just like you can a
native Access table.

File, Get External Data, Link Tables.
Change "Files of Type" to OUTLOOK.
Then you should be able to see the Address book. Link to that.

Then you can do lookups or whatever you want.

Can't find pointers? Really? Did ya try searching this NG? I know
for a fact they're here. I've been reading them for the past five or
six years...

[someone]

Pieter,

Thankyou for the input.

Regarding not finding any pointers, sorry but that was because I was
actually looking for access to the GAL, not a users PAB. I know I put
PAB but it was a very long day and I was extremely tired and some
would say confused.

I have subsequently found out from a website that you can't link to
the GAL unless you use Outlook 98 or higher.

Sorry for the confusion and thanks for your reply,

Tony W

On 6 Dec 2003 20:46:03 -0800, pi********@hotm ail.com (Pieter Linden)
wrote:

so*****@home.c om wrote in message news:<cm******* *************** **********@4ax. com>...

Hi,

I currently have an Access 97 database that includes a field for
contact name of a user. This user will almost always have a valid
email address contained in the personal address book of the person who
inputs the records into the database.

At present the person inputting the records has to manually look up
the correct address and copy in into the field. I know that it should
be possible to lookup that address by some form of automation but I
can't find any pointers anywhere.

Any help or advice on this would be most appreciated.

TIA

Tony W

How about creating a linked table? link to Outlook, then choose
AddressBook or whatever, and then you can query it just like you can a
native Access table.

File, Get External Data, Link Tables.
Change "Files of Type" to OUTLOOK.
Then you should be able to see the Address book. Link to that.

Then you can do lookups or whatever you want.

Can't find pointers? Really? Did ya try searching this NG? I know
for a fact they're here. I've been reading them for the past five or
six years...