displaying the outlook address book in excel

  • Thread starter Thread starter mahesh
  • Start date Start date
M

mahesh

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
 
mahesh < wrote
I'd rather have the dialog box that pops up in outlook itself.
Click to expand...

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

ActiveWorkbook.SendMail ""
 
Back
Top