Ron - I am using your site listed below to automatically send an email when a
cell reaches a certain number. I have tested the "cell is a formula" code in
a blank workbook by simply summing a column of 1's. It works great right up
until I make the manually typed 1's become a formula themselves - like an if
statement to say 1 or 0 depending on something in another column. After
doing this, the macro to call the email macro will not run. I do not know
VBA code that well, but I've gotten by with things like you offer (the cut
and paste it method) and things have worked out pretty well. Is the macro not
working when the formula cell itself is summing other cells that are also
formulas?

JenP

"Ron de Bruin" wrote:

Hi Johnson

See
http://www.rondebruin.nl/sendmail.htm

You can use a event to run the macro
See this page
http://www.cpearson.com/excel/events.htm


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


"Johnson" wrote in message ...
I want to automatic the process that when I finish my daily routing of excel
VBA and it can be auto-triggerd the Outlook to send an email with this excel
file as an attachment
--
Johnosn