Thread: Accessing Outlooks address book via VBA embedded in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Accessing Outlooks address book via VBA embedded in Excel
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 Bruin
http://www.rondebruin.nl/tips.htm


"Phil Martin" wrote in message ...
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?
Reply With QuoteReply With Quote