send email with attachment

Dear experts
Which code can send email with attached with sheet1. Without alert ?

Dun know it work for excel vba or not !
Kindly help

Maybe your best bet for now is to have a look at this site.


http://www.rondebruin.nl/win/s1/outlook/mail.htm

Originally Posted by jolivanes

Maybe your best bet for now is to have a look at this site.


http://www.rondebruin.nl/win/s1/outlook/mail.htm

thanks very much ...
i find the code with can send a what i want but, how do change the code without a pop up alert to send directly ? which made me very annoying