Ron - I apologize - I need to add on my last email that my 1's are
calculating from data from an MS QUERY....it seems like when the query is in
the spreadsheet this VBA code does not want to work? Any help would be
greatly appreciated.

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