Hi everyone, I have found a few examples online however my knowledge of coding is so basic I can't edit them to make it work in my scenario...
Any help would be massively appreciated! My boss has given me a tight deadline and I'm lost...
What I need to do
Any help would be massively appreciated! My boss has given me a tight deadline and I'm lost...
What I need to do
- Export current active sheet (Print Area Only) as a PDF
- Save the File with the contents of Cell I1 as the file name
- Save the file to Q:\3. PCR Reporting
- Attach the file to a new message in Outlook and display
- Leave To & CC Blank
- Subject: Cell I1 with no file format
- Body
- Hi, Test (I will fill this in)