I was wondering if there is any way to e-mail the cells and its contents of an excel sheet using vb. I would like it to be sent in the body of the e-mail rather than an attachment and I would like to keep the cells so that the information can be copied and pasted by the recipient of the e-mail without it copying the entire text of the e-mail. Was just wondering if it could be done.

I also need some help with checking information on several sheets in a workbook. I have a workbook with the following sheets. Sheet1 is named duh. The second sheet is named big_duh. The third sheet is named biggest_duh. Now what I would like to do is click a button and have it check cell a1 to see if the number is greater than 50. If it is above 50 do something if it is not then I want it to go to the next sheet and do the same thing until it has gone through all the sheets. Now there will be sheets added to this at a latter time and the number of pages and names will be changing all the time.

How can I get it to recognize the number of sheets, the names of each sheet and then advance to the next sheet if I don't have any idea how many sheets there will be or what the sheets may be named?