Mail merge
When you run a standard mail merge in Word, each record from your data source starts on a new page. This wastes paper and makes printing labels, directories, or price lists inefficient. The cause is the default page break that Word inserts after each merged record. This article explains how to remove those page breaks … Read more
You run a mail merge in Word and the resulting documents show blank fields where names, addresses, or other data should appear. This usually happens because the data source — an Excel file, Outlook contacts, or a database — is not properly connected to Word or because field codes are mismatched. This article explains the … Read more
After running a mail merge in Word, you often end up with one large document containing all letters, invoices, or labels. Saving each merged record as a separate PDF file is not a built-in single-click feature. This article explains three reliable methods to split a mail merge output into individual PDFs: using a VBA macro, … Read more
You need to send the same email to many recipients without typing each one. Mail merge in Word combined with Outlook automates this task by pulling recipient data from a list and generating personalized messages. This article explains how to set up a mail merge from start to finish, covering the data source, the main … Read more
When you run a mail merge in Word, the default greeting line inserts a generic salutation for every recipient. You need a greeting that changes based on data like gender, title, or relationship type. Word does not offer a built-in button for conditional salutations, but you can achieve this using the IF field code combined … Read more
You need to send personalized letters, emails, or labels to a group of people whose contact information is stored in a SharePoint list. Word’s mail merge feature can pull data directly from that SharePoint list instead of requiring you to export or copy the data first. This article explains how to connect Word to a … Read more
When you run a standard mail merge in Word, each recipient gets their own letter. But sometimes you need one letter addressed to multiple people at the same company or household. For example, you might want to send a single notice to both John Smith and Jane Smith at the same address. The default mail … Read more
When you run a mail merge in Word, the final output shows merged data from your source file — names, addresses, or other fields — combined with your main document. Without previewing, you risk printing letters that contain blank fields, incorrect data, or formatting errors that waste paper and time. Word provides built-in preview tools … Read more
You have a finished Word document such as a contract, letter, or flyer. You want to reuse its layout and text for a mail merge without starting from scratch. A mail merge template is a .docx file that contains field codes for recipient data like names and addresses. This article shows how to convert your … Read more
You need to automate a mail merge in Word without clicking through the ribbon every time. Running a mail merge from a macro lets you generate hundreds of personalized letters, emails, or labels with one command. This article explains how to write and execute a VBA macro that performs a full mail merge from start … Read more