One way would be to group the sheets before you save and close the
workbook(s). When they are opened and printed all the sheets will be
printed.

Regards

Trevor


"Homebody" wrote in message
...
I send a lot of excel workbooks as email attachments in Outlook. The
recipient of the attachementss prints all of the attachements at once by
selecting the letter and pressing "File", "print" , and checking print all
attachemtns radial button on the resulting Outlook dropdown menu. When
this
is done only the active sheets prints.

Excel 2003 and Outlook 2003