iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Word’s normal mail-merge command creates one document containing every personalized letter. To get one PDF cover letter per recipient, use one of two dependable workflows: run a VBA macro that merges and exports one record at a time, or create the combined merged document first and split it into individual letters before exporting. The macro is the efficient choice for recurring or large batches; splitting is easier when you only have a few letters to process.
Why Word creates one merged document
Mail merge is designed to produce a batch of personalized letters. Microsoft describes the letters as having the same layout, formatting, text and graphics, with personalized elements such as the salutation changing for each recipient. Word therefore treats the merged output as one document unless you deliberately process records separately.
The standard command does not include a one-click option that automatically names and saves every record as its own PDF. Finish & Merge > Edit Individual Documents creates a new document containing the entire merged set. That document is the correct starting point for review, printing or manual splitting, but it is not yet a folder of separate PDFs.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Prepare the merge before exporting PDFs
Use a stable recipient field for filenames
Choose a field that uniquely identifies each recipient, such as a candidate ID, employee number or surname. A unique ID is safer than a name because two recipients may share a surname. Keep the field free of characters that operating systems reject in filenames: / : * ? " < > |.
#1 Best Overall
- Powerful Turbo Fan:CAGIWIRU Electric Air Duster have reached speed up to 130000RPM,Can efficient remove dust and debris.With LED light and Three Adjustable Speed to meet with different cleaning tasks.
- With Attached USB C Fasting Charging cable.Charing 3 hours,Enjoy up to 240 minutes of use on the lowest setting, For third speed can use for 25mins.with four charging options to meet with your needs.
- Wide Application: attached 5 different nozzles,making it suitable for a variety of scenes, such as car,pet, pc, keyboards, and other electronic devices. It also serves for office and home clean duster.
- Handy Design & Portable:Cordless air duster electric nozzle is Light weight and small size, design and comfortable to hold and space saving, convenient to carry around. You can put it in your room or inside the car without taking up space.
- Economical &Reusable: Built durable materials with a long-lasting battery,our CAGIWIRU air duster it's a sustainable alternative to disposable air cans.
Save a working copy of the template
Duplicate the original Word mail-merge template before running a macro or making page-level edits. The macro changes the merge range while it runs, and manual splitting can involve deleting or copying pages. Keeping the source template unchanged gives you a clean starting point for a later batch.
Create an empty output folder
Use a dedicated folder for the PDFs. An empty folder makes it obvious which files belong to the current run and reduces the chance that a rerun overwrites unrelated documents. Decide whether your organization permits macros and document-splitting utilities before choosing a method.
Official Word workflow: build the merged working document
Complete these steps regardless of whether you will use VBA or split the output manually:
Free tools Windows power users keep installed
One-click scans. No signup required.
Rank #2
- Screen Cleaner is Your Screen’s New Bestfriend! - EVEO is proud to present a screen cleaner that’s perfectly suited for your TV. Meet your new screen cleaner, computer screen cleaner, laptop cleaner, iPad cleaner, Macbook,tv cleaner or any other electronic device. Our screen cleaner spray and wipe along with the included plush microfiber cloth, easily removes dust, fingerprints & other smudges on the screen’s surface. Clean effectively for a streak-free screen
- Gentle on your Screens - Our screen cleaner spray and wipes is compatible to be used even for the most sensitive LCD, LED, CRT, and OLED screens in proper use. Be at ease knowing that this product is compatible with all the major brands: LG, SONY, Samsung, Sharp, iPad, iPhone, Android screens, Kindle, PC monitors - we’ve got you covered! Can be used as LCD screen cleaner, tv cleaner, smart tv screen cleaner, and more
- Premium Super Soft Plush Microfiber Cloth - Included in this efficient screen cleaning kit. This screen cleaner spray and wipe has our signature plush microfiber cloth specially designed to comply with screens and monitors and leave them streak-free. Has been shown to effectively absorbs stubborn stains, zero streaks, and no fiber shedding. Always use this together with our screen cleaner for the best results
- Easy-to-Use Screen Cleaner Kit + microfiber cleaning cloth - The EVEO Screen Cleaning Kit will easily be your new favorite tool when it comes to taking care of the things you love most, quick and easy solution for a streak-free screen. Simply screw on the sprayer gun on the screen cleaner bottle. Spray the cleaning liquid onto the microfiber cloth, then wipe the screen until desired cleanliness & shine is achieved.
- Quality Screen Care Kit Worth Purchasing - Enjoy a convenient Screen Cleaner anytime, anywhere you need it. Your satisfaction is our top priority. We stand behind the quality of our products and that’s why, you shouldn’t be worrying at all. We manufacture the Best Screen Cleaner. and can be used for laptop cleaning kit, laptop screen cleaner, tv screen cleaner for smart tv. MacBook screen cleaner, monitor cleaner or screen cleaner spray for electronic devices with microfiber cleaning cloth
- Open the letter template in Word.
- Choose Mailings > Start Mail Merge > Letters.
- Choose Select Recipients and connect the recipient list.
- Insert the required merge fields, such as name, address and company.
- Choose Mailings > Preview Results. Move through several records, including the first and last, to check names, addresses, salutations and page layout.
- When the preview is correct, choose Finish & Merge > Edit Individual Documents.
- In the recipient range dialog, select all records or the range you need, then select OK.
- Word opens a new document containing the merged letters. Save that document as a working copy before exporting or splitting it.
Inspect the working copy rather than the template when checking the final text. The merged document contains the actual recipient values and is the document that will be converted or divided into PDFs.
Method A: export one PDF per record with VBA
A macro can loop through the data source, set FirstRecord and LastRecord to the same record, merge that single record into a temporary document, export the temporary document with ExportAsFixedFormat, and close it. Repeating that sequence creates one PDF per recipient without requiring you to split a large document.
When this method is the better choice
- You run cover-letter batches regularly.
- The batch contains enough records that manual page handling would be tedious.
- You need deterministic filenames based on a merge field.
- You want reruns to follow the same naming rule.
Macro execution can be blocked by an organization’s security policy. Word menu names and macro behavior can also vary between Microsoft 365 builds and between Windows and Mac installations. If your installation does not permit the macro, use the split-and-export workflow instead.
Rank #3
- 【Large size】：Measuring 800 x 300 mm/ 31. 5×12 inches, which is wider and taller than others. Large mouse pad can perfectly fit your keyboard and mouse of any size, and there is also ample space for peripherals such as phones, tablets, etc.
- 【LED backlight mouse pad】：Blade Hawks RGB mouse pad provides 7 static modes and 7 dynamic modes will give you the options you are looking for. Power-off memory function remembers the last lighting mode you selected. The super glow fiber Chroma will give you a colorful gaming setup that you want.
- 【Anti-slip rubber base】：Made from Natural rubber, this gaming mousepad will firmly grip your desktop, allowing you to enjoy the ultimate precision in the games you are most passionate about. It also comes with a texture that enhances this ability even further.
- 【Smooth and waterproof surface】: Micro-textured cloth surface, for extremely precise mouse control and a smooth movement. When liquid splashes on the gaming mouse pad, it forms water droplets and slides down. Will not delay your work or gameplay.
- 【Plug and play】: This mouse and keyboard pad is powered by USB, plug and play, no driver required. One button control light modes. Press one time to change the lighting mode, press twice to change the brightness, press and hold about 3 seconds turn ON/OFF.
Example macro
The following pattern exports one record at a time. It assumes the data source has a field named Surname; change NAME_FIELD to the exact field name in your recipient list. Change OUTPUT_FOLDER to a folder path valid on your computer, and include the final path separator.
Option Explicit
Private Const OUTPUT_FOLDER As String = "C:MailMergePDF"
Private Const NAME_FIELD As String = "Surname"
Sub ExportMergeRecordsToPDF()
Dim mainDoc As Document
Dim mergedDoc As Document
Dim data As MailMergeDataSource
Dim recordNumber As Long
Dim recordCount As Long
Dim stem As String
Dim outputName As String
Set mainDoc = ActiveDocument
If mainDoc.MailMerge.MainDocumentType = wdNotAMergeDocument Then
MsgBox "Open the mail-merge main document before running this macro."
Exit Sub
End If
Set data = mainDoc.MailMerge.DataSource
recordCount = data.RecordCount
If recordCount < 1 Then
MsgBox "The recipient list contains no records."
Exit Sub
End If
For recordNumber = 1 To recordCount
With mainDoc.MailMerge
.DataSource.FirstRecord = recordNumber
.DataSource.LastRecord = recordNumber
.Destination = wdSendToNewDocument
.Execute Pause:=False
End With
Set mergedDoc = ActiveDocument
stem = CleanFileName(data.DataFields(NAME_FIELD).Value)
If Len(stem) = 0 Then
stem = "Record-" & Format(recordNumber, "0000")
End If
outputName = OUTPUT_FOLDER & Format(recordNumber, "0000") & "-" & stem & ".pdf"
mergedDoc.ExportAsFixedFormat _
OutputFileName:=outputName, _
ExportFormat:=wdExportFormatPDF
mergedDoc.Close SaveChanges:=False
Next recordNumber
MsgBox "Export complete."
End Sub
Private Function CleanFileName(ByVal value As String) As String
Dim badCharacters As Variant
Dim character As Variant
badCharacters = Array("", "/", ":", "*", "?", Chr$(34), "<", ">", "|")
CleanFileName = Trim$(value)
For Each character In badCharacters
CleanFileName = Replace(CleanFileName, character, "-")
Next character
End FunctionThe code prefixes each filename with a zero-padded record number. That keeps files in recipient-list order and prevents identical surnames from producing the same name. For example, a surname value of Garcia could become 0007-Garcia.pdf. The number is the position in the current data source, not a claim that the recipient has a particular ID.
Run the macro cautiously
- Save the template copy and confirm that the recipient list is connected.
- Open Word’s Visual Basic editor, insert a standard module, and paste the macro.
- Set the output folder and merge-field name to values that exist in your environment.
- Run the macro on a small range first. You can temporarily replace the loop limits with a short record range while checking the result.
- Open several generated PDFs. Verify that the recipient, salutation, address and page count match the intended record.
- After the small run is correct, restore the full record range and run the batch into the dedicated output folder.
Do not edit the main template while the macro is running. Each temporary merged document is closed after export; leaving those documents open can consume memory and make it difficult to tell which files were successfully written.
Rank #4
- 【Softer and More Comfortable】Vaydeer wrist rest has unique diamond pattern, which is the combination of softness and aesthetics. The materials of wrist rest are improved into higher quality memory foam and covered with silky smooth lycra. The computer wrist rest makes you as comfortable and cushiony as like rest your wrists on clouds.
- 【Ergonomic Wrist Saver】The wrist rests for keyboard and mouse comes with a 17.32×3.15×0.83 inch keyboard wrist pad and a 5.94×3.15×0.83 inch mouse wrist support. Based on ergonomic design, the unique concave shape is the perfect fit for your wrist joints. The wrist rest pad fits most computer keyboards and laptops, improve hand and wrist posture, release your wrist and arm stress.
- 【Non-Slip Rubber Bottom】Featuring an anti-skid silicone base on the bottom, this wrist keyboard support stays firmly in place on your desk, preventing the padding from sliding around, ensuring stable and consistent wrist support during extended computer sessions.
- 【Better Experience & Pain Relief】Our keyboard arm rest is beneficial to alleviate the soreness caused by direct contact and friction between your arm and a hard desk surface, reducing the risk of wrist fatigue or carpal tunnel. The soft texture of memory foam can evenly distribute the pressure around your wrists and provide good support with just enough give.
- 【Helpful in Multiple Scenarios】Whether you're working, studying, writing, typing, gaming, this keyboard and mouse rest combo is an essential accessory to add comfort and support to your hands and wrists. It’s also a great gift for men, women, family, friend, coworker, gamer, teacher, etc.
Common VBA problems
- “Subscript out of range” or a missing field error: the value in
NAME_FIELDdoes not exactly match the data-source field name. Check the recipient-list column name, including spaces. - No PDFs appear: the output path may not exist or may use the wrong path syntax for your operating system. Create the folder first and replace the constant with a valid local path.
- Files have the wrong recipient: confirm that the macro is running from the merge main document, not from the temporary merged document, and rerun the preview check.
- Existing files are overwritten: use the dedicated folder and add a more unique field, such as a candidate ID, to the filename rule.
- The macro will not run: organizational macro restrictions may be preventing execution. Do not bypass a security policy; use the manual method or ask your administrator for an approved process.
Method B: merge, split, then export
For a small or occasional batch, the reviewable route is to make the combined merged document, divide it into one document per letter, and export those documents as PDFs.
Step 1: create and inspect the combined document
- Follow the official workflow above through Finish & Merge > Edit Individual Documents.
- Save the merged document under a new working filename.
- Check that the number of letters is what you expected from the recipient range.
- Confirm that every letter begins on the intended page. A letter that spills onto an extra page will change the page boundaries used for splitting.
Step 2: divide the letters
Split by record when each record has a predictable boundary. If every cover letter is exactly one page, page-based splitting is straightforward. If some letters occupy two pages, split at the start of each recipient’s letter rather than assuming a fixed page count.
You can copy each letter into its own Word document, use a PDF editor after exporting the combined document, or use a document-splitting utility approved by your organization. Word’s standard merge command does not automatically create and name these individual files, so the separation step remains manual or requires another approved tool.
Best Value
- 【No Drill Mounted】Cable management tray can be assembled in as little as 3 minutes or less-simply. Side clips easily clampe the edge of desk, pass through the holes on the sides, and secure excess cables with baskets. Desk cable management supports inward or outward installation to meet your needs in different scenarios, and provides you with great convenience when collecting and organizing wires.
- 【Rubber Pad Protects Desk】Wire organizer under desk built-in soft rubber pads on the clamp protect your desk from scratches, so you will not damage your furniture or office.
- 【Sturdy and Beautiful】Cord management under desk is made of high-quality carbon steel and holds about 15 lbs. The wire basket has 2 holes on each side of the tray to enable your cables to pass freely. Cable baskets are suitable for desk thickness use from 0.4" to 2.4".
- 【Space Saving & Keep Organized】Desk cable management tray holds all your power cords, outlet strips, USB hubs and computer transformers hidden from your feet, and the data cables will not enter the vacuum cleaner to keep your desk clean and tidy. Desk wire organizer is also suitable for use in the kitchen and outdoors.
- 【Reduce Safety Risks】Cable tray under desk keeps all plugs away from your kids, no more worry about tripping. Using 2 holes wire tray saves extra space, helps you easily cabling and wire protection. The mesh design is not easy to accumulate dust, but avoids safety accidents caused by messy wires.
Step 3: export and name each PDF
- Open each separated Word document.
- Use Word’s PDF export or save-as-PDF command available in your build.
- Name the PDF from the recipient list, preferably with a unique ID followed by a readable name.
- Save every PDF in the dedicated output folder.
- Open the PDFs and check that no letter contains the previous or next recipient’s page.
This method is slower than VBA for a large batch, but it lets you inspect the complete merged set before any PDF is created. That review can be valuable when layout changes, conditional text or variable-length addresses may cause some letters to occupy different numbers of pages.
Which method should you use?
| Decision factor | VBA per-record export | Merge, split and export |
|---|---|---|
| Best batch size | Recurring or large batches | A few letters or occasional batches |
| Filename control | Deterministic; generated from a chosen merge field and record number | Manual; each filename must be checked while saving |
| Review before PDF creation | Requires deliberate sample checks and post-export review | Easy to inspect the complete merged document first |
| Setup effort | Higher initially because the macro and path must be configured | Low technical setup, but more hands-on file work |
| Policy dependency | Requires permission to run VBA | Uses ordinary Word editing and an approved splitting or PDF workflow |
| Risk to manage | Wrong field, path, record range or overwrite rule can affect many files | Incorrect page boundaries or inconsistent manual filenames |
If you will repeat the task, invest time in the macro and a reliable identifier field. If the batch is short and the letters need close visual review, create the merged working document and split it manually.
Filename and quality-control checklist
Before creating files
- The template is a copy of the original.
- The recipient list is the correct version and contains the intended records.
- The identifier field is populated and contains no prohibited filename characters.
- The output folder is dedicated to this batch.
- You have confirmed whether macro execution is allowed.
After creating files
- The file count matches the number of recipients processed.
- Each filename identifies one recipient without ambiguity.
- Names, addresses, salutations and company details match the corresponding record.
- Page breaks do not cut off text or combine two recipients in one PDF.
- PDFs open successfully and contain the expected letter only.
- A rerun will not silently overwrite unrelated files.
Word versions and platform considerations
Microsoft’s mail-merge support documentation covers Microsoft 365, Word 2024, Word 2021, Word 2019 and Word 2016, with Windows and Mac applicability shown on the support page. The underlying workflow is the same—connect recipients, preview, then finish the merge—but labels and dialog details can differ between builds.
Recommended Free Tools
The VBA approach also depends on the local macro policy and the path format accepted by the operating system. Treat the example code as a pattern to adapt: verify the field name, output path, security policy and available PDF export command in your Word installation. When those conditions are uncertain, the merge-and-split workflow avoids relying on a macro.
Final recommendation
Word does not natively turn a standard mail merge into a set of separately named PDFs with one command. For repeatable production, export each record in a controlled VBA loop, sanitize the filename field, use a dedicated folder and validate a small range before processing the full list. For a short batch, use Edit Individual Documents, inspect the combined result, split at each letter boundary and export each document individually.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
