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