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,
pietlinden@hotmail.com (Pieter Linden)
wrote:
[color=blue]
>someone@home.com wrote in message news:<cmfvsvo4gtej51f7889o6iea0g4569t4t9@4ax.com>. ..[color=green]
>> 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[/color]
>
>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...[/color]
