Ive been searching and found bits that let me save as PDF and email, but not together. Im not well versed in VBA so havent been able to figure out how to link them. What Im after is the following:
- Save current sheet as a PDF
- Save into a specific folder “C:\Folder1\Folder2” without the folder select dialog box appearing
- file name defined in a cell (say X10) [Cell A will say 12345---67890 for example, so i need to add the ".pdf" after as .pdf wont be in the cell
- Then open outlook to send the attachment to Person1@hotmail.com (static name)
- And CC in email address in cell B1
- Subject line is “ABunchOfWords “ and Cell A1 (combined)
- With body message as “words” & Cell “Y10” & “words”
- With outlook preview of the message displayed and viewable and editable before clicking Send