send individual sheets as email

[NickBrandt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Does anyone know if it is possible to send single sheets from a workbook as attachments to emails, rather than the whole workbook?

this would be particularly useful in many instances for me where we have a workbook containing product requirements and calculations on different sheets within a workbook but do not want to send the whole book to a customer for quoting.

Similarly different sheets may have different product list on them which need to be sent to different suppliers and it does not make sense to send all suppliers all the product lists which are not appropriate to them.

Currently I have to make a separate workbook for each sheet in order to send them out. This generates a huge amount of work reformatting etc.

help please!!

nick

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Does anyone know if it is possible to send single sheets from a workbook as
attachments to emails, rather than the whole workbook?

this would be particularly useful in many instances for me where we have a
workbook containing product requirements and calculations on different sheets
within a workbook but do not want to send the whole book to a customer for
quoting.

Similarly different sheets may have different product list on them which need
to be sent to different suppliers and it does not make sense to send all
suppliers all the product lists which are not appropriate to them.

Currently I have to make a separate workbook for each sheet in order to send
them out. This generates a huge amount of work reformatting etc.

Do you need to send worksheets, or will PDFs do?

If the latter, you can choose File/Print, selecting the "Active Sheets"
radio button in the Print dialog's "Print What" section, then choose
Entourage from the Print dialog's PDF dropdown.

If it needs to be an Excel sheet, you can choose Edit/MOve or Copy
Sheet..., copy the sheet to a new workbook, then send that workbook.