I have a workbook with a pivot table and multiple spreadsheets. How do I email each spreadsheet in the workbook to different people? I only want that one person to be able to view just the spreadsheet I am sending them not the entire workbook or other spreadsheets. I have been saving the workbook as xxxx report and then deleting the other data and worksheets that do not pertain to that person and then emailing that workbook, very time consuming considering I have 20 people to send a report to. Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Emailing spreadsheets, not entire workbook?
- Thread starter cc0623
- Start date
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
If you're using Outlook, see Excel Automation - Ron de Bruin
He's got all the code you need to e-mail workbooks and worksheets. You'll probably want to look at the routine that creates a copy of a sheet, mails it, then kills it.
Are the sheets named for the individuals to whom they'll be sent?
He's got all the code you need to e-mail workbooks and worksheets. You'll probably want to look at the routine that creates a copy of a sheet, mails it, then kills it.
Are the sheets named for the individuals to whom they'll be sent?
Upvote
0
