Excel macro help needed for Mail

I am using Excel, macro, and for 4 days I have been unsuccessful at
sending my current sheet. The reason I am using a macro is that I
will be porting this to the web, when it is done. Here is the full
story:

1. This is sheet 1 of a 4 sheet Excel workbook. I can send it as an
attachment, but when the recipient opens it all of the workbooks have
the same name. Of course this generates an error from Excel.

Here is the macro that I have tried, but the name of the workbook
transmits unchanged (I dummied the recipient's email address):

Please Login or Register  to view this content.

If there is anyway that I could alter the workbook
name that would be great. Of course the program flow passes on to the
next statement.


2. I am at a complete loss as to how to send the current page with
an Excel macro. My intention is to make the page unique.

Either #1 or 2 would be a great solution for me.

# # # # #