Excel 2003

[GOVMATE]

I have a large voucher report that consists of about 250 tabs (separate offices) in an excel workbook. Does anyone know of a of way to email only one report "tab" via MS Outlook after opening the work and selecting only the report tab that a user would like to distribute without the email message body displaying the other tabs that are also in the workbook.

Any suggestions are greatly appreciated!!!!

Thanks!

 

[MI man]

I couldn't get through clearly, but (presuming that you want to send the application as an attachment through email) if you can use some code in VBA which displays an input box prompting you to input the desired spreadsheet name which after clicking OK ...


1. Hides all the other spreadsheets except for the one that is desired.


Or


2. Copies only the desired spreadsheet to another workbook . You can send this new workbook as an attachment in your email.


The 2nd method would give your email a lesser size in relation the 1st method, as only the desired spreadsheet is being sent instead of all.


Hope this idea works....!!

 

[GOVMATE]

MI man,

Thanks for the advice! For the time being I will tell my end users to do the simple approach. Copy and paste into another spreadsheet