| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending emails from Excel
I am programing my excel to send pre formatted emails to people if certain conditions are met. Is there an alternative to this: Set MailRecipients = MailItem.Recipients.Add ("Broker1Email") Eg MailItem.Recipients = " " Can I have the program automatically say yes to Outlook's dialogue box requesting that allow the program to access the address book? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending emails from Excel
Hi David
Read this http://www.rondebruin.nl/sendmail.htm#Prevent -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "David Robinson" wrote in message ... I am programing my excel to send pre formatted emails to people if certain conditions are met. Is there an alternative to this: Set MailRecipients = MailItem.Recipients.Add ("Broker1Email") Eg MailItem.Recipients = " " Can I have the program automatically say yes to Outlook's dialogue box requesting that allow the program to access the address book? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending emails from Excel with Outlook Signature | Excel Discussion (Misc queries) | |||
| Sending batch emails via Excel | Excel Discussion (Misc queries) | |||
| Sending multiple EMails thru excel? | Excel Discussion (Misc queries) | |||
| Help Sending Emails From Excel | Excel Discussion (Misc queries) | |||
| Excel VBA sending emails (using iNotes) | Excel Programming | |||
![David Robinson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
