email portion of spreadsheet as attachment

H

Holly K

I have a spreadsheet with over 500 rows. I would like to email, as an
attachment, only those rows that pertain to each salesman. How would I do
that without allowing them to see the whole workbook.
 
P

Peo Sjoblom

You could apply autofilter, filter on that specific salesman, copy to a new
workbook and email that workbook, of course you could autmate that through VBA

Here are some techniques

http://www.rondebruin.nl/sendmail.htm

Ron also has an add-in for sending emails that you can install


Regards,

Peo Sjoblom
 
Top