View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Phil Martin Phil Martin is offline
external usenet poster
 
Posts: 4
Default Accessing Outlooks address book via VBA embedded in Excel

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" 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 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?