mail filtered sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there
I have got an Excel Database that I filter after customers.
What I want to do know is to send this filtered sheet to the customer per mail as attachement. How can I do that with beeing sure that they don't get the whole lot

Your help is very apprechiate

Thank
MAtt
 
Once you have filtered your list (click somewhere inside the range
displayed) then at the menu, click on Edit,
Goto.. then the Special Button.. click Visible Cells only. Then Copy
(Ctl-C) and Paste-Special-Values to sheet1 of a new workbook say -
Paul021104.xls. e-mail this new workbook as an attachment.
HTH

Matt said:
Hi there,
I have got an Excel Database that I filter after customers.
What I want to do know is to send this filtered sheet to the customer per
Click to expand...
mail as attachement. How can I do that with beeing sure that they don't get
the whole lot?
 
My SendMail Add-in have this option Matt
Or use the code Example on my site
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Matt said:
Hi there,
I have got an Excel Database that I filter after customers.
What I want to do know is to send this filtered sheet to the customer per mail as attachement. How can I do that with beeing
Click to expand...
sure that they don't get the whole lot?
 
Back
Top