Help to combine two Modules from seperate workbooks to one workbook preform task

Yes, kinda - I need the PDF to be saved to the local drive with the naming path listed in the code then take that PDF and put it in an email.

Hello AlphaFrog,

THANK YOU VERY MUCH for your link, but I have to say, I have SO little experience with VB Code that I have no idea what you link is telling me. I've tried to find and paste code that I thought would work, and for the most part it does work. The current part of the code that I have working is - once the Submit Order button is Clicked and the Order Acknowledge button is clicked the PDF is saved and placed in the directory that I've instructed in the the code. Below are the problems that I'm still having and hoping someone can help:

1.) A copy of the Order Sheet is created and appears on the screen; however, I do not want that to appear - I know the issue is the Sheets("Order Form").Copy, but when I get rid of the code the - none of the other parts of it works.
2.) A PDF copy appears; however, the attaching of the PDF to outlooks does not work.
3.) After the UserForm1 is clicked, I want it to disapear but it does not, you have to X out of it.

The code I found, looks like it should work; however, I think the probem has to do with the Title and the little section in the code, I have no idea on how to tell it to use the PDF that I just created.

I realize I may be asking alot here, so PLEASE accept my request with knowledge that I COMPLETELY APPRECIATE any help you can offer. Below is the code that I'm trying to use:

Please Login or Register  to view this content.

Hello AlphaFrog,

I'm sorry, I can't attach my workbook because it contains many pricebooks links and private information. GOOD news is - I've been able to figure out the code to fix my problems #1 and #3. Bad news is, I still can't figure out how to send the "Newly Created" PDF into an outlook email.

I'm sorry that I can't provide you more infomation to help me, I guess I will have to keep searching.

THANK YOU AGAIN, for ALL of your Assistance. To all of you out here on this website who are offering your knowledge, Thank you - you are all pretty AMAZING!

THANK YOU - THANK YOU - THANK YOU! AlphaFrog, I went back to the file that you sent me and tried to get understanding. I was finally able to work through the files and got - everything works PERFECT! Thank you so much for your assistance, it's GREATLY appreciated!