View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default sending email within a macro

It actually appears to be a warning within Outlook 2003.
The .displayalerts didn't work on my machine. Are you
running Outlook 2003?


-----Original Message-----
I tested this and it worked in a macro of mine without

any
prompt. Try this:

Application.DisplayAlerts = False
ActiveWorkbook.SendMail "
Application.DisplayAlerts = True

-IA

-----Original Message-----
In my endless quest to automate my personal files, I'm
trying to have a macro email my cells in the body of an
email. I've done this using the

ActiveWorkbook.SendMail recipients:="Jean Selva"

vb command. Works great, just as I wanted. The only
problem is that it STILL prompts for user input. A
warning pops up saying that a program is automatically
sending email on my behalf. I must then wait 5 seconds
and press "yes."

How can I get rid of this warning. I haven't been able
to take vacation time because the data I send out is
critical, and I'm trying to get this stuff automated.
.

.