How do I send single worksheets in a workbook to different recipi.

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

Guest

I have a requirement to send a number of worksheets from a single workbook.
Each sheet is sent to a different recipient, all sheets are sent at the same
time and a macro/VBA routine would be ideal for this purpose. I do not want
to send the whole workbook. The work sheets are Pivot Table reports.
 
' put copy of sheet in new workbook
activesheet.copy
' remove links in copy
' also removes the pivot table capability but
' the data is left
activesheet.copy
activesheet.pastespecial xlValues
activeworkbook.Senmail . . .
activeworkbook.close SaveChanges:=False


you would just loop through the appropriate sheets and use code similar to
the above.
 
You must log in or register to reply here.

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

Error Message - Macro to Unlink MS Queries from Workbook 0
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Macro for all Excel Workbooks to print to PDF 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Combine multiple worksheets in one Workbook into one big worksheet 6
How to append data from different sheet and different workbook? 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Select Previously Selected worksheet (and/or select previouslyselected workbook) 5

Back
Top