How to Create a Word Directory Mail Merge with a Single Cover Page
Question details
The user needs to perform a directory-style mail merge without repeating the cover and information pages for every individual merged record.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Creating a combined document consisting of a single cover page, an information page, and a continuous directory section containing merged data.
- Observed behavior
- The directory mail merge repeats the cover page and information page for every data record instead of displaying them once and starting the merged records on page three.
Ensure your Excel data source is properly formatted by placing field names in the first row, avoiding special characters, and limiting header names to 40 characters or less.
Configure a Standard Directory Mail Merge
Use Word's Directory merge feature and handle the cover page separately to avoid repetition.
A standard Letters mail merge creates a new page for every record, which causes any cover page included in the template to repeat. Switching to a Directory merge lists records continuously, but including a cover page inside the main merge document can still cause formatting issues.
Open your main document in Word. Navigate to the 'Mailings' tab, click 'Start Mail Merge', and select 'Directory' from the dropdown list.
To prevent repetition, delete the cover page and information page from your mail merge template. Keep only the fields necessary for the continuous directory list.
Click 'Finish & Merge' and choose 'Edit Individual Documents'. This generates a new document containing your continuous directory data.
Open the newly generated directory document. Go to the 'Insert' tab, click 'Cover Page', and add your desired cover and information pages at the very beginning of this final output.
Use a Many-to-One Mail Merge Add-in
Utilize a third-party macro or add-in to group multiple records under a single heading or document.
Create Seamless Mail Merges with WPS Writer
WPS Writer provides a powerful and intuitive Mail Merge feature that lets you create directories, letters, and labels with ease. It perfectly handles complex data sources while maintaining compatibility with your existing Office files.
- 1. Open WPS Writer: Launch WPS Writer and navigate to the 'References' tab on the top ribbon.
- 2. Select Data Source: Click 'Mail Merge' and choose 'Open Data Source' to connect your Excel spreadsheet.
- 3. Insert Merge Fields: Place your cursor where you want the data to appear, then click 'Insert Merge Field' to add your data columns.
- 4. Merge to Document: Click 'Merge to New Document' to generate your final directory or grouped list.
Frequently Asked Questions
Why does my mail merge repeat the header on every page?
If your merge repeats headers or cover pages for every record, it is likely set to a 'Letters' document type. Letters create a new document section per record. To create a continuous list, change the merge type to 'Directory' under the Start Mail Merge menu.
What is a Many-to-One mail merge?
A Many-to-One mail merge is an advanced merge technique that groups multiple child records (like a list of purchased items) under a single parent record (like a customer's name), rather than printing a new page for every single item.
Can I use Excel data for a directory mail merge?
Yes. Excel worksheets are standard data sources for mail merges. Ensure your data is clean, with all column labels located strictly in the first row and containing no blank columns or complex formatting.
