linking outlooks address book with MS Access

[sha7jpm]

anyone know of a way to link a form to the address book in outlook?
.
the idea being that instead of storing the email addresses on access the user picks up the address book and select the emails recipients they want.

also this would allow for about two users to be always emailed as they are copied into every email sent.

any tips?

 

[charityg]

If you are using Access XP, you can simply link the address book as a table. Choose link table then select Outlook from the "Files of Type" dropdown. I know you can't do this in Access97, but I'm not sure about Access2000.

 

[Jeff Bailey]

If you are using A97 there is a free download (wzmapi80.exe) that allows you to link to Outlook's address book.

 

[sha7jpm]

great!

thanks jeff,

do you have the location of the download?

ta

John

 

[charityg]

http://www.microsoft.com/downloads/release.asp?ReleaseID=12878&area=search&ordinal=1