View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_22_] Jeff[_22_] is offline
external usenet poster
 
Posts: 1
Default emailing recipients from a list in Excel

I have the code to e-mail a spreadsheet and/or a reference
of cells to multiple recipients if I list the recipients
in the code. (recipients = array:("user1", "user2"))

Is there a way to have the code reference the spreadsheet
for the list of names instead of having them hard coded?

Also, Is there a way to turn off the security prompt that
either Outlook or Excel displays when sending an email?
(You are about to send an e-mail, are you sure you want to
do this?)

Thanks in advance!!