How can I automate an e-mail to be send in macro?

[Guest]

My name is John. I am running a program in excell that runs macro. Part of
this macro is to automaticaly send an e-mail with the spreadsheet attached. I
get the warning that a program is trying to send e-mail on your behalf. The
options I have are Yes, No or Help. How can I stop this warning message
from appearing?

 

[Ron de Bruin]

Hi John

http://www.rondebruin.nl/mail/prevent.htm

 

[Crowbar via OfficeKB.com]

Hi

At the start of the macro type:

Application.DisplayAlerts = False

and you wont get any warnings

You can use

Application.ScreenUpdating = False

this stops you seeing the macro doing its stuff (therefore your macro will
run faster)

 

[Ron de Bruin]

Hi Crowbar

This is not working for the Outlook or Outlook Express security warning.

 

[Crowbar via OfficeKB.com]

Private sub AutoEmail()

ActiveWorkbook.SendMail Recipients:="(e-mail address removed)"

end sub

This works for me!

The only trouble is, is that outlook must be open or they won't send, I use
this daily to send to 50 people and never get a message

 

[Ron de Bruin]

In Outlook Express you can turn it of
http://www.rondebruin.nl/mail/prevent.htm

Or you use Excel 97 or 2000 not up to date

 

[Crowbar via OfficeKB.com]

Your right mate,

I'm using an old version at work

I'm out of ideas

Why not downgrade? (only kiddin)