|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 11:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com