| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Outlooks address book via VBA embedded in Excel
Hi Ron,
Works perfectly, thanks very much "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Phil Martin" wrote in message ... 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address book to excel | Excel Discussion (Misc queries) | |||
| excel as address book | Excel Discussion (Misc queries) | |||
| Using Outlook address book in Excel | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| How to insert an address from Outlook 2003 address book ? | Excel Programming | |||
Threaded Mode
