Email on sheet from a workbook through outlook

I have attached a dummy file that I am working with (it is not a macro enabled workbook but I know it will need to be when this is figured out). What I would like to do is take one sheet( the active sheet ) in a workbook that I have open and mail it through outlook. I would like the subject line to be whatever is in the cell next to P.O. Number. I would like the title of the attachment to also be whatever is in the cell next to P.O. Number. I do not need the body of the email in vba. Also, I would like to display the email so that I can choose who I send it to. If anyone can help with this I would greatly appreciate it. If you need any more information please let me know.

Thank you in advance.

Hi dhes5555

Please look at this link...it does as you describe. If you need help adapting please let me know.
http://www.rondebruin.nl/mail/folder2/mail2.htm

Hi dhes5555

At a minimum, I'd need to see your code to help with this

I would like the temporary file name to be named whatever is in cell i2. I would also like the subject line to be whatever is in cell i2.

Are we still working with your attached sample file?

Hi dhes5555

When I run your code with Sheet cnc the ACTIVE sheet AND there's a value in Cell H4 the code runs fine. It creates a file with the name of Cell H4 and the subject line is the value of H4. The only issue I have is the created file is an .xlsm file and has links.

So, you need to explain your process and what you wish to happen...perhaps we can help.

Hi dhes5555

Explain your process...I'll see if I can duplicate the issue.

Hi dhes5555

You can place the procedure in your Personal.xls(b) workbook then add that reference to your quick access toolbar. Check out this link.
http://www.lytebyte.com/2008/09/09/h...in-excel-2007/

You're welcome...appreciate the Rep.