Connecting Outlook with Excel - HELP

Excelboy_01

New Member
Joined
Aug 5, 2011
Messages
32
Hello People,
I have created an excel sheet where I have to enter names of people, many of whom their names are just too difficult, not to mention that the process is time consuming. However, I have most of them in my MS Outlook (2003). I would like to have the option so that if I click on a cell, instead of me writing the name, it opens me my Outlook contacts list so that I can simply select the name as opposed to typing it.

Any knows how I can do that? VBE Code..or any other way would be highly appreciated.

Thanks in advance
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You'll need 2 things:
  1. Something to detect the fact that you selected a cell
  2. Something to bring up the Outlook Address Book
I can help with (2)
You have a whole Outlook VBA object model available to you. First you have to enable it from Excel by adding it as a reference in the VBA Developer.
You can then use that object model to bring up contact items and match to the name in the cell. And there is a dialog box you can bring up to prompt for a name using the std outlook dialog - I have created one of these but can't access it.
Of course, your more likely to get help on Outlook from a specialist site!

mike
 
Upvote 0
First you have to enable it from Excel by adding it as a reference in the VBA Developer. You can then use that object model to bring up contact items and match to the name in the cell. And there is a dialog box you can bring up to prompt for a name using the std outlook dialog - I have created one of these but can't access it.
mike

Thanks for your tips and time Mike. However, I am still not sure how to "enable outlook from Excel [by adding it as reference in the VBA Developer]" as you stated. Would you be kind enough to give some steps to follow -- in a lame man's language that is .

Thanks a bunch
 
Upvote 0
Tools -> Macro -> VBA Developer (I am on 2003 here. It is different for 2007)
Tools (in VBA) -> References
Select Microsoft Outlook Object Library and click OK
 
Upvote 0
Many thanks Mike,
I have now completed the second part, but seems I still nned to acomplish the 1st part in order for it to work. Lets hope someone else will offer me additional tips.
Grateful
 
Upvote 0

Forum statistics

Threads
1,224,586
Messages
6,179,722
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top