Sorry, I can't seem to view the original message.

You can do this in CDO, see he http://www.outlookcode.com/d/code/selectnames.htm

Also there is a method in Outlook 2007, if you have it:
http://msdn2.microsoft.com/en-us/library/bb208172.aspx

HTH,
JP

On Jan 29, 12:08*pm, "Ron de Bruin" wrote:
Hi Phil

Display the mail and let the user choose

Do you use SendMail *in the code or the Outlook object model

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Phil Martin" wrote in ...
I have a spreadsheet that mails itself to an end user upon completion. The
recipient is specified by the user. At the moment this is by using inputbox.
What I would like to do is bring up the Outlook address book and let the user
select the email address from that. Is that possible?- Hide quoted text -

- Show quoted text -