Why is my email code sending a blank email?

Hello everyone,
I thought I had this all figured out, (thanks to Leith) but alas, I don't. I have code that creates a sheet with updated information only, which is by date and currentuser. Then it is supposed to email that sheet as and HTML in the body of the email. This is all done when a user clicks a button on the userform. Everything works as expected except the email part of the code. Instead of emailing it as HTML in the body of the email, it attaches it to the email but the email and attachment are blank. Can someone take a look at the code below and see where I have gone wrong, please?

Please Login or Register  to view this content.

Sorry about the lengthy code.

I'm not sure you've posted the correct code. This function converts a range of cells to HTML. Perhaps there is another macro calling this function and also creating the email that isn't working?

Jerry,
Thank you for the response. I wasn't sure if I should include the other code or not, that is why I left it out. You are correct though, there is another macro calling this function, here it is......

Please Login or Register  to view this content.

Ok, I've used that code before, I'm sure we all have. I don't see anything obvious wrong with that email code. Comment out this line:

Please Login or Register  to view this content.

....hopefully a meaningful error will occur and your can DEBUG to see which line of code is failing you.

Ok, it errors out at this line...

Please Login or Register  to view this content.

As well as this line....

Please Login or Register  to view this content.

When I remove the On Error Resume Next lines individually

You're failing on the object name, the name of the sheet doesn't match what you're feeding in in some way. What was the error? Subscript out of range? That means a named object is is incorrect.

My bad, I can't believe I didn't include the error I was getting. I will update with the error this morning.

Jerry,
Ok, I figured out the first part (I think). I removed the "On error resume next" as you suggested. Then I noticed there was an "If error = 9" so I removed that as well as it was just "skipping" that part anyway and creating and naming the sheet like I wanted. Now I get a "Run-time error 438: Object doesn't support this property or method" at this line..

Please Login or Register  to view this content.

I will play around with it some more to see if I can get it figured out. If I don't post anything, I haven't figured it out and could still use your help.

Edit* Ok, I figured something else out. The first bit of code I posted is creating a temp file and the line it errors out on is "getting" that temp file (in the original code before I started changing things around). The problem is that the temp file has nothing in it, the information I am trying to grab is actually put into a newly created worksheet (End of shift Report) that is in the same workbook that the code and is in.
My question is, what does the

Please Login or Register  to view this content.

need to be in order for me to pull the information from the newly created sheet in the active workbook?

Solved per this thread
http://www.excelforum.com/excel-prog...-with-vba.html
Thank you Gregor Y