email portion of spreadsheet as attachment

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My rows keep "unhiding" when I do not want them to 6
Email workbook to multiple individuals with their specific data 3
Email Spreadsheet As Attachment? 7
.net formatting data in excel 2
send only a portion of a workbook 1
Excel shortcut options 0
Deleting excess rows from a spreadsheet 1
Macro to email filtered section as attachment 6

Top