Every time we find something worth sharing we will post an article on it here.
Export PowerPoint Slides as PDF with Title
Exporting each slide of a PowerPoint presentation as separate PDF documents can be time consuming. We provide a small VBA script to do this.
Batch Protect PDFs with Different Passwords
We provide a script for automatically password protecting multiple PDF files, each one with a different password, for free – no fees or software purchase required.
Enhanced Mail Merge to Email – add Attachments, Custom Subject, Save to Drafts and more
Use Word mail merge to send emails, with all the missing features added back in. Features like adding attachments, having a custom subject, using the CC and BCC fields, using “Send As” (e.g. send as the CEO – you know you want to), and best of all you can save to drafts to check the emails before they go out.
Word Mail Merge to Separate PDFs with Custom File Names and Folder Locations
Convert your Word Mail Merge into separate PDF documents! No third-party plug-in, no complexity, and no need to go moving and renaming documents.
VLOOKUP is Dead, Long Live FILTER
All the limitations of VLOOKUP, INDEX-MATCH or even XLOOKUP can be solved by using FILTER and SORT instead. Read on to find out how to do a “VLOOKUP” with multiple criteria and how to handle multiple matches.