At the moment I have a macro which copies a couple of sheets in the open
file and puts them into a new file. A bit of fomatting is then done and the
user is prompted to save the file.

My boss has now decided to get rid of the part which saves the file, he
would like this to be replaced by other code which puts the new file into a
message and sends it automatically.

Can this be done?

Any help gratefully received.

Gareth

Check out this site
http://www.rondebruin.nl/sendmail.htm

Post back if you need help

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Gareth" wrote in message ...
At the moment I have a macro which copies a couple of sheets in the open
file and puts them into a new file. A bit of fomatting is then done and the
user is prompted to save the file.

My boss has now decided to get rid of the part which saves the file, he
would like this to be replaced by other code which puts the new file into a
message and sends it automatically.

Can this be done?

Any help gratefully received.

Gareth