Email only the filtered data

[Guest]

I have filters on several columns in a spreadsheet (Excel 2002). I know I
can do File-Send To-Mail Recipient and email a "picture" of the filtered data
to someone. However, if I use File-Send To-Mail Recipient (as Attachment),
the recipient can remove the filters and view all of the data. Is there a
way to send only the filtered data to the recipient and they cannot expand
the columns to show everything? I'm banging my head on my desk!

Thanks,
Stephanie

 

[Ron de Bruin]

Hi Stephanie

I have example code on my site to send only the visible cells in ther selection
http://www.rondebruin.nl/sendmail.htm

But If you can also use my Add-in to do it
http://www.rondebruin.nl/mail/add-in.htm

 

[Ron de Bruin]

Note : the add-in have only a option to send the visible cells in a file.
There are code examples for body and attachment on my site.

 

[Guest]

Wow! I really appreciate your response, but that is way over my head. I
will need to Protect the worksheet before mailing. ....and take an Excel
class! Thank you, Ron!

Stephanie

 

[Ron de Bruin]

Hi Stephanie

Tell me your mail program and i will make an example for you that
also protect the sheet.

 

[Guest]

Ron,

The spreadsheet I am creating will be used by multiple people. Each
individual will apply various filters and email those portions to others. We
all use Microsoft Outlook 2002. I was trying to find a simple solution to
email pertinent info while hiding internal info. Does this make sense or am
I being too basic?

Stephanie