Merge Excel Data into Separate DOCX and PDF Documents
Would you like to automate the creation of personalized Word documents? Learn how to combine an Excel list with a Word master document and generate…
Blog
Step-by-step Excel and Word tutorials and technology for the classroom.
Bulk QR Code Generator from Excel
Discover a new way to generate QR codes: straight from Excel. The "Bulk QR Code Generator" turns your spreadsheet into a factory of instant…
Send Bulk Emails with Word
Sending bulk emails with Word is an essential tool for businesses and professionals who need to reach a large audience efficiently. Learn step by…
How to Send Bulk Emails from an Excel List Using Macros and Outlook
Need to send bulk emails quickly and efficiently? This step-by-step guide shows you how to build an email list in Excel and use a VBA macro with…
.jpg)
How to Create QR Codes That Never Expire
How do you create QR codes that never expire? Some people think the question makes no sense, but expiring QR codes are real. Here I explain how to…
Convert Numbers to Words in Excel with Macros
Converting numbers to words in Excel is a feature every Excel user wishes were built in, but unfortunately it takes a little extra work. Here is how…
What You Need to Know About Barcodes in Excel
Barcodes in Excel are a form of encoding that identifies products and items so they can be counted and controlled correctly. Here you will learn the…
Mail Merge to Individual PDF Files
Word's Mail Merge puts every record into one single document. Here is how to merge from Excel and save each record as its own PDF file using a…
Send Emails WITHOUT Macros from Excel 365 and 2019
Learn how to send emails straight from Excel 365 and 2019 without writing a single macro, using the HYPERLINK function and Outlook. The recipient…
Mail Merge and Save as Separate Documents
If you have to generate 500 individual letters, creating and saving each document one by one by hand would be very tedious. Here is how to merge and…