Email a single sheet from a workbook

**rkjudy** · 09-30-2009, 11:35 AM

I have a spreadsheet that has approx 10 different sheets (tabs at the bottom). I want to write a routine that will take one of the sheets, copy it to a new workbook, and email the newly created workbook using Outlook. I've entered this question once before and got some suggestions that seemed to work for a while. Then it became hit and miss as to whether it worked or not. Now I'm geting a "Can't create object" error everytime. I want to break this one sheet out and send only it because I don't want to send the entire workbook.

The code that I'm currently using is below. Any suggestions?

Please Login or Register  to view this content.

**royUK** · 09-30-2009, 11:43 AM

There's plenty of examples here

**rkjudy** · 10-01-2009, 05:41 PM

Got it going. Thanks

**royUK** · 10-02-2009, 04:11 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save