Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending messages
I have a lot of example code on my site David
http://www.rondebruin.nl/sendmail.htm If you need help post back -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "david robinson" wrote in message ... I am writing a routine to send emails to email recipients if certain conditions are met on a spreadsheet. Is there a simpler alternative to Set Mail Recipients = MailItem.Recipients.Add My vba returns an error when I use: MailItem.Recipients = addressee's email Also my vba asks me if I want to allow the program to access my email. Is there a simple command that will say yes to this request automatically so I can send several emails one after another without having to say "yes" each time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Messages | Excel Worksheet Functions | |||
Messages | Excel Worksheet Functions | |||
Not getting messages in OE | Excel Worksheet Functions | |||
Msg.box -messages | Excel Discussion (Misc queries) | |||
Sending Text Messages with Excel??? | Excel Worksheet Functions |