View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ed ed is offline
external usenet poster
 
Posts: 59
Default Email from Excel

Hi

I am using a macro to automatically send a copy of a
spreadsheet using outlook but when i run this i get an
dialogue box from outlook saying

'A program is trying to automatically send mail on your
behalf

D you want to allow this?'

Is there any way of getting rid of this box as i am
sending this to many people and i dont want to keep
clicking yes?

Thanks in advance for your help.

Ed