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

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?

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

Hi John

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"john" wrote in message ...
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?

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

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)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1

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

Hi Crowbar

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Crowbar via OfficeKB.com" <u15117@uwe wrote in message news:5ae5ce9c0a0fd@uwe...
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)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1

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

Private sub AutoEmail()

ActiveWorkbook.SendMail "

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1

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

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Crowbar via OfficeKB.com" <u15117@uwe wrote in message news:5ae662431f6c5@uwe...
Private sub AutoEmail()

ActiveWorkbook.SendMail "

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1

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

Your right mate,

I'm using an old version at work

I'm out of ideas

Why not downgrade? (only kiddin) :-)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1