Accessing Outlooks address book via VBA embedded in Excel

[Phil Martin]

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?

 

[Ron de Bruin]

Hi Phil

Display the mail and let the user choose

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

 

[JP]

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

You can do this in CDO, see here: 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

 

[Phil Martin]

Hi Ron,

The sendmail is in the code. At the moment the user does not see the mail.
It acts like it is a background process

 

[Ron de Bruin]

Hi Phil

Then use

.SendMail "", _
"This is the Subject line"

If the To is "" empty it will display the mail and the user can use the address book

 

[Phil Martin]

Hi Ron,

Works perfectly, thanks very much

Hi Phil

Then use

.SendMail "", _
"This is the Subject line"

If the To is "" empty it will display the mail and the user can use the address book