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 ""
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull Recipient from Outlook Address book 6
accessing Outlook Address book from Excel VBA 5
Accessing Outlooks address book via VBA embedded in Excel 5
Get Outlook Address Book info 5
Get Contact from a Global Address list? 0
Export Macro to new Workbook based on Email Address 7
Address Book 5
Word Create a Phone Book using MailMerge in word 2007 0

Back
Top