| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Email only the filtered data
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 |
|
#2
|
|||
|
|||
|
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 -- Regards Ron de Bruin http://www.rondebruin.nl "stefani13" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
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. -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl "stefani13" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
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" wrote: 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. -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl "stefani13" wrote in message ... 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 |
|
#5
|
|||
|
|||
|
Hi Stephanie
Tell me your mail program and i will make an example for you that also protect the sheet. -- Regards Ron de Bruin http://www.rondebruin.nl "stefani13" wrote in message ... 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" wrote: 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. -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl "stefani13" wrote in message ... 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 |
|
#6
|
|||
|
|||
|
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 "Ron de Bruin" wrote: Hi Stephanie Tell me your mail program and i will make an example for you that also protect the sheet. -- Regards Ron de Bruin http://www.rondebruin.nl "stefani13" wrote in message ... 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" wrote: 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. -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl "stefani13" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Filtered Data | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| How to have total for filtered data?? | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions | |||
Linear Mode
