Need help with UserForm that saves the worksheet as PDF and email via Outlook - Excel 2007

Hi,

Ive created a Userform that has textboxes which closely resemble Microsoft Outlook New Email message window. I have linked my 'To', 'Cc', 'Subject' to Outlook and also got the 'Attach File' button working. I can't however create a PDF from the worksheet and attach it to new mail message, and i cant attach any other files that ive selected and provided the path in the AttachFile textbox. Can someone help with:

1. Create PDF from Sheet1 and name it as text entered in "File Name" textbox in the Userform.
2. Attach it to Outlook when Send button is clicked and any other files selected via "Attach File" button
3. Get the high priority button working
4. Preview before sending when checkbox1 is True, and Send directly when checkbox1 is False





Thanks for you help!

See the attached file

User Form 7 with PDF and Email.xlsm