LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending emails from Excel with Outlook Signature Erik Excel Discussion (Misc queries) 1 April 24th 06 07:14 PM
Sending batch emails via Excel treetop40 Excel Discussion (Misc queries) 0 April 24th 06 11:22 AM
Sending multiple EMails thru excel? Bigredno8 Excel Discussion (Misc queries) 2 October 27th 05 10:37 AM
Help Sending Emails From Excel mrk0 Excel Discussion (Misc queries) 1 July 6th 05 06:42 PM
Excel VBA sending emails (using iNotes) Trevor Shuttleworth Excel Programming 3 August 28th 03 07:26 PM


All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"