displaying the outlook address book in excel

Can someone please help.

I have been trying to display the outlook address book in excel usin
VBA, so that users can select mail recipients directly in exce
itself.

Is there any way to do this?

I can use the (outlook.addresslists.addressentries) object, but th
global address book I am trying to access has 50000+records.

I'd rather have the dialog box that pops up in outlook itself.

Many thank

--
Message posted from http://www.ExcelForum.com