View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
John Huang John Huang is offline
external usenet poster
 
Posts: 1
Default Automatically e-mailing a sheet

Hi Joshua,


In your email, you stated tthe followin:

Remember to have your default email program configured, it will also
ask/tell you that a program is trying to send mail without you doing
anything, just select not to tell/ask you again. That way it can
happen at night without any user interaction

I don't know where to set up in MS exchange. Could you help?

John Huang

"Joshua Stollar" wrote:

Workbook(Index).Activate
ActiveWorkbook.SendMail Recipients:="", Subject:="",
ReturnReceipt:=True or False

Remember to have your default email program configured, it will also
ask/tell you that a program is trying to send mail without you doing
anything, just select not to tell/ask you again. That way it can
happen at night without any user interaction.