| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Outlooks address book via VBA embedded in Excel
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing Outlooks address book via VBA embedded in Excel
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 - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing Outlooks address book via VBA embedded in Excel
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? |
|
#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? |
| Reply |
| 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 | |||
Linear Mode
