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

displaying the outlook address book in excel
 

mahesh < wrote

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

Probably not exactly what you're looking for, but this pops open the dialog
that will let you click on To:

ActiveWorkbook.SendMail ""

--
David