Populate a Combo Box with people from Outlook

[SpiritedAway]

Hi,

I have a form [frmInterface] with a combo box [globalcombo] - what I had it mind is having the combo box with a lookup where I can populate it with names from my global address in Outlook.

After I have selected the person I want - I want to then be able to come back to that record at anytime, double click that persons name to open up an email from Outlook with that persons email address.

Does anyone have any suggestions or advise or demos about how I can achieve that?

Any help would be greatly appreciated!

I'm using Access and Outlook 2007

Spirited Away.

 

[John Big Booty]

Perhaps this article will give you some ideas

 

[John Big Booty]

...check this thread it has some samples in it.

 

[SpiritedAway]

Thanks John - I will pursue the links you've provided and let you know how I get on.