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.
Bookmarks