Hi Holly

Install my SendMail Add-in
There is a option to send only the visible cells
http://www.rondebruin.nl/

Use AutoFilter to Filter on the salesman first


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Holly K" <Holly wrote in message ...
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.