Word’s normal mail-merge command creates one merged document, not one PDF per recipient. To produce separate cover-letter PDFs, use one of two dependable workflows: run a VBA macro that merges and exports each record individually, or create the complete merged document first, split it into one document per letter, and then export those documents as PDFs. The macro is the better choice for recurring or large batches; splitting is usually faster for a small, occasional batch.
What Word mail merge does—and what it does not do
Microsoft describes mail merge as a way to create a batch of personalized letters in which the layout, formatting, text and graphics stay the same while fields such as the salutation, name, address or company change for each recipient. Word’s built-in merge flow is designed to print the batch or create one editable document containing every letter. It does not include a standard one-click command that automatically names and saves every merged letter as a separate PDF.
As an Amazon Associate I earn from qualifying purchases.
That distinction matters because choosing File > Save As > PDF after a normal merge produces one PDF containing all of the letters. You must either export records one at a time through automation or separate the merged output before exporting.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Choose the right workflow
| Situation | Recommended method | Why |
|---|---|---|
| A few letters, one-time job | Merge, split, then export | You can review the entire merged set visually without setting up a macro. |
| Recurring batches or dozens of recipients | VBA per-record export | The macro repeats the same merge and PDF-export steps and can create deterministic filenames. |
| Strict filename convention | VBA per-record export | A surname, candidate ID or other merge field can be incorporated into each filename. |
| Macros blocked by policy | Merge, split, then export | Manual or approved document-splitting tools avoid macro execution. |
| Every letter needs individual editing | Merge with Edit Individual Documents | The merged document lets you inspect and modify each letter before conversion. |
Prepare the template and recipient list
Use a stable data source
Keep the recipient list in a form Word can read consistently, such as an Excel worksheet or another supported data source. Give the fields clear names—for example, FirstName, LastName, Company, Address and CandidateID. A unique ID is safer for filenames than a name alone because two recipients can share a surname.
#1 Best Overall
- [Ultra-Lightweight Ear Buds Designed for Small Ears] Each earbud weighs only 3.7g and features a compact, ergonomic in-ear design made especially for small ears. Secure, low-profile, and comfortable for workouts, all-day wear or overnight sleeping.The ultra-slim profile sits flush in your ear with no hard edges poking or rubbing, so you can even sleep on your side without discomfort.
- [Immersive Stereo Sound with TOZO OrigX Technology] TOZO OrigX tuning delivers clear vocals, balanced mids, and natural stereo sound for music, podcasts, and videos.
- [Long Battery Life for Daily Use] Get up to 7 hours of playtime on a single charge, with up to 32 hours total using the charging case—ideal for workdays, commuting, and extended listening sessions.
- [Bluetooth 5.3 & Stable Connection] Bluetooth 5.3 provides fast pairing, stable wireless performance, and reduced dropouts as you move around home or office.
- [Deep Bass with Clear Vocals] High-performance drivers produce punchy bass while keeping vocals clean and detailed for everyday listening.
- Check that every row represents one recipient and that the header row contains field names.
- Remove blank rows from the range used by the merge.
- Standardize values before merging; inconsistent capitalization or trailing spaces will appear in the PDFs.
- Keep a backup of the data file and the original Word template.
Design the cover-letter template
Open a copy of the template and place the merge fields where the personalized values belong. Include the recipient’s name, address, company and salutation as needed. Keep the page breaks and section layout stable: a letter that unexpectedly flows onto a second page will affect how a split workflow identifies records.
Official Word merge sequence
The following sequence applies to the Word editions covered by Microsoft’s support documentation: Microsoft 365, Word 2024, Word 2021, Word 2019 and Word 2016. The exact menu appearance can vary between Windows, Mac and individual Microsoft 365 builds.
- Open the mail-merge template in Word.
- Choose Mailings > Start Mail Merge > Letters.
- Choose Select Recipients, then connect the recipient list. If the list is already attached, verify that the correct file and table or worksheet are selected.
- Insert the required fields with Mailings > Insert Merge Field. Typical fields include first name, last name, street address, city, state or province, postal code and company.
- Choose Mailings > Preview Results and use the previous/next record controls to inspect several recipients, including the first and last records.
- Choose Finish & Merge > Edit Individual Documents.
- In the recipient dialog, select All or the required range, then choose OK. Word creates a new document containing the merged letters.
- Save that new merged document as a working copy. Do not overwrite the reusable template.
At this point you have a combined document. Continue with Method A for automated per-record PDFs or Method B for a manual split.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallMethod A: export one PDF per record with VBA
When this method is appropriate
Use VBA when the same process will be repeated, when the batch is large, or when filenames must be generated from merge data. The macro limits each merge to one record, exports the resulting temporary document as a PDF, closes that temporary document, and moves to the next record.
Rank #2
- 【IP68 Waterproof Multifunctinal Smart Watch】Torjalph fitness activity tracker smart watch is IP68 waterproof technology ,you can wear it when swimming,handwashing,it's rain-proof which means that you perform multiple exercise modes outside without worrying about sweat or rain corroding your fitness smart watch,and this watch equipped with a 230 mAh large capacity battery magnetic charging ,and this sports activity tracker watch can be used 5-7 days If fully charged.
- 【Larger 1.83'' Full Screen Watch & Multi-dial Selection】1.83 inch full HD color touch screen smart watch for men / women provides excellent 240*284 resolution image quality ,This Bluetooth smart watch offers a better touch experience and remarkable immersion and ,more than 200 watch faces for you to choose from App"Da Fit ", you can change the dial style according to your mood to wear keeping the world on your wrist
- 【Accurate Activity Tracker Smart Watch 】sports watch activity tracker uses sweat and dust resistant breathable silicone strap, our Fitness Tracker Smart Watch for Android iOS Phones supports 12 sports modes,walking,running,bicycle,swimming,badminton,basketball,football,rope skipping. This bluetooth calls smart watch for men women is lightweight and stylish, bringing more convenient and relaxing sports experience while also providing more protection.
- 【Your 24 Hour Personal Daily Health Monitor】Fitness watch for women men full touch screen IP67 waterproof bluetooth smartwatch for Android iOS Phones with heart rate blood pressure monitor multifunction Andriod smart watch with steps counter sleep monitor sports fitness watch, monitoring blood oxygen saturation allows you to understand your physical condition in real time to track fitness progress ,to know your health status in time.
- 【More Functions Bluetooth Call Smart Watch】This fitness activity smart watch full screen for iPhone and Android phones includes a bunch of new features including:The bluetooth smart watch can hang up the phone, receive and display WhatsAPP /Text /Facebook /Twitter /Messenger reminder.Support sedentary reminder, alarm clock, stopwatch, timer,weather information,music control, remote camera control compatible with Android 5.0 and above or iOS 9.0 and above smartphones.
Macro execution can be restricted by your organization’s security policy. Only run code you understand and are permitted to use. Store the template and output folder in a trusted location approved by your administrator.
Create a dedicated output folder
Create an empty folder before running the macro, such as C:MailMergePDFs. An empty folder makes it obvious which files belong to the current run and reduces the risk of overwriting unrelated PDFs. If you use a different path, include the final backslash in the value assigned to outFolder.
Insert the macro
- Open the original mail-merge template or a working copy in Word for Windows.
- Press Alt+F11 to open the Visual Basic Editor.
- Choose Insert > Module.
- Paste the code below into the module.
- Change
outFolderto your approved output folder. - Change
CandidateIDto the exact merge-field name you want to use in filenames. If that field does not exist, use a field such asLastName. - Save the document in a macro-enabled format such as
.docm, subject to your organization’s policy.
Option Explicit
Sub ExportMergeLettersToPDF()
Dim templateDoc As Document
Dim mergedDoc As Document
Dim data As MailMergeDataSource
Dim outFolder As String
Dim baseName As String
Dim fileName As String
Dim i As Long
Dim total As Long
Set templateDoc = ActiveDocument
outFolder = "C:MailMergePDFs"
If Right$(outFolder, 1) <> "" Then outFolder = outFolder & ""
If Dir$(outFolder, vbDirectory) = vbNullString Then
MsgBox "Output folder not found: " & outFolder, vbExclamation
Exit Sub
End If
With templateDoc.MailMerge
If .MainDocumentType = wdNotAMergeDocument Then
MsgBox "Open a mail-merge letter template before running the macro.", vbExclamation
Exit Sub
End If
Set data = .DataSource
total = data.RecordCount
For i = 1 To total
data.ActiveRecord = i
.DataSource.FirstRecord = i
.DataSource.LastRecord = i
.Destination = wdSendToNewDocument
.Execute Pause:=False
Set mergedDoc = ActiveDocument
baseName = CleanFileName(data.DataFields("CandidateID").Value)
If Len(baseName) = 0 Then baseName = "record_" & Format$(i, "0000")
fileName = outFolder & Format$(i, "0000") & "_" & baseName & ".pdf"
mergedDoc.ExportAsFixedFormat _
OutputFileName:=fileName, _
ExportFormat:=wdExportFormatPDF
mergedDoc.Close SaveChanges:=False
templateDoc.Activate
Next i
End With
MsgBox CStr(total) & " PDF file(s) exported to " & outFolder, vbInformation
End Sub
Function CleanFileName(ByVal value As String) As String
Dim badCharacters As Variant
Dim character As Variant
badCharacters = Array("", "/", ":", "*", "?", """", "<", ">", "|")
CleanFileName = Trim$(value)
For Each character In badCharacters
CleanFileName = Replace$(CleanFileName, character, "_")
Next character
End FunctionThe macro uses ExportAsFixedFormat with wdExportFormatPDF, the Word automation pattern used for exporting a document to PDF. It prefixes each file with a four-digit record number so that file systems sort the batch in merge order, then appends the selected merge-field value.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Adapt the filename field safely
Replace CandidateID with the exact field name shown in your data source. If you use a surname, duplicate surnames can produce confusing names, so retain the record-number prefix or combine two fields in the macro. Windows does not allow these characters in filenames: / : * ? " < > |. The CleanFileName function changes them to underscores and supplies a record-number fallback when the field is blank.
Rank #3
- [Low Noise High Fidelity] New bee guitar cord with 22AWG oxygen-free-copper center conductors provides enhanced signal transfer, the PVC insulation material and the high-density stranded copper double shield provide noise rejection for quiet operation
- [Ideal for Choice] New bee 1/4 straight and right angle metal connectors, ensures a secure connection in any instrument, pedal, or amp jack. L shape great fro on stage guitar stands
- [Wide Compatible] Suitable for mixer, power amplifier, microphone, effector, decoder, equalizer, electoronic organ, electric guitar, electric bass and other electronic equipments. Widely used in the installation of smart home, karaoke speaker, professional stage audio, etc
- [Easy Disassemble] Making incidental repairs quick and easy! Very nice, flexible cable
- [Dont Hesite to Order] 24 hours customer services and professional technology team are standing by
Run a controlled test
- Filter the recipient list to a small range or temporarily use a copy containing only a few rows.
- Run Developer > Macros, select
ExportMergeLettersToPDF, and choose Run. - Open every generated PDF in the output folder.
- Confirm that the name, address and other fields match the intended recipient and that the page count is correct.
- After the small run succeeds, restore the full recipient list and run the batch in the empty output folder.
Keep the template open while the macro runs. Each temporary merged document is closed after export, while the original template remains available for the next record.
Method B: merge, split, then export
Build and review the combined document
Follow the official sequence through Finish & Merge > Edit Individual Documents. The resulting document is useful when a human must inspect or adjust every letter before PDFs are produced. Save it as a separate working file so the original template remains reusable.
Confirm record boundaries
Check that each letter begins on the intended page. A standard letter merge often places one record per page, but a long address block, a changed font, a manual page break or a section setting can make a letter span multiple pages. Count the expected records and compare that count with the merged output before splitting.
Recommended Free Tools
Split the output
Use the document-splitting capability available and approved by your organization. Depending on the tool, you can split by page range, by section or by a delimiter that appears at each record boundary. For a small batch, copy each letter into a new Word document and save it with a recipient-based name. For a larger batch, use an approved Word or PDF utility that can split a combined file into individual documents.
Rank #4
- Digital Family Calendar: BSIMB digital calendar wall touch screen puts an end to your chaotic life. Designed for busy families, the digital calendar keeps you organised and in step with your family. Assign different colours and tasks to each family member to make family scheduling easier and more intuitive.
- Easy Setup and Auto-Sync: Plug in, connect to WLAN and auto-syn your electric calendar in minutes. Digital wall calendar compatible with Google calendar, iCloud calendar, Outlook calendar, Cozi calendar and Yahoo calendar. Add events directly on the device or through the ecalendar app. Electronic calendar stays current whether you're at work or traveling—no manual updates needed.
- All-In-One Home Assistant: Smart calendar builds habits and encourage independence with personalised chores. Display daily meal plan to reduce the daily ‘What's for dinner?’ stress. To-do lists keep track of everything you want. Turning chores into valuable achievements with stars and rewards, making life easier and more enjoyable.
- Manage Anytime Anywhere: BSIMB electronic calendar for family stay connected with the powerful ecalendar app. Access and manage your digital wall calendar anytime, anywhere with free features like stars & rewards, photo screensaver, chore charts, meals plans, to-do lists etc. Electronic planner paid features like Magic Import tailor advanced tools for users with special needs.
- Stay in Touch with Loved Ones: Share photos or videos from your phone to electronic wall calendar with app, instantly update your life moment, and keep in touch with your family, especially those who are far away; you can also surprise your smart calendar digital wall by sending him a wish card; it's also great for keeping tech-illiterate elders in touch with the youngsters.
- Identify the page or page range belonging to the first recipient.
- Copy or extract that range into a separate document.
- Name the document with a unique recipient value, preferably an ID plus surname.
- Repeat for each record, checking the first and last page of every extracted letter.
- Open each resulting Word document and choose File > Save As or File > Export, then select PDF.
Manual splitting gives you direct review control, but it requires careful naming and page-boundary checks. It is easy to omit a page, include the next recipient’s page or overwrite a file if names are not unique.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Quality checks before sending the PDFs
- Recipient identity: The name, address, company and salutation belong to the same data row.
- Pagination: No letter is truncated, and a multi-page letter keeps its pages together.
- Formatting: Fonts, logos, margins, signatures and graphics render as intended.
- Field results: Empty optional fields do not leave awkward punctuation or extra blank lines.
- Filenames: Every file is unique, readable and free of prohibited filesystem characters.
- Count: The number of PDFs equals the number of recipients selected for the merge.
- Privacy: The output folder is access-controlled and temporary merged files are removed when no longer needed.
Troubleshooting common failures
The macro says the output folder is missing
Check the spelling and capitalization of outFolder, confirm that the drive is connected, and include the trailing backslash. If the folder is on a network share, verify that your account has permission to create files there. Testing with a local approved folder can distinguish a path problem from a merge problem.
The macro creates one PDF containing every letter
The merge range was not limited to the current record. Confirm that FirstRecord and LastRecord are both set to i before Execute, and that the destination is wdSendToNewDocument. Run the macro on a small data copy and inspect the page count of each PDF.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Filenames are blank, duplicated or rejected
Verify that the field name in DataFields("CandidateID") exactly matches the merge-field name. Check the source values for blanks and duplicate IDs. Keep the numeric record prefix, and let the sanitizing function replace characters that the file system rejects.
Merge fields appear as field names or remain unchanged
Use Mailings > Preview Results in the template before running the macro. Confirm that the correct recipient list is attached and that the fields were inserted with Insert Merge Field, not typed as ordinary text. Reconnect the data source if the worksheet or table was moved.
A letter spills onto an extra page
Inspect the source data for unusually long addresses or company names, then check paragraph spacing, font substitution, margins and manual page breaks in the template. In a split workflow, treat every page belonging to that recipient as one unit rather than assuming one page equals one letter.
Word blocks the macro
Macro security is controlled by Word and, in managed environments, by organizational policy. Do not lower security settings without authorization. Use the merge-and-split workflow or ask your administrator for an approved way to run signed or trusted macros.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesThe menu labels do not match
Word’s labels can differ between Windows, Mac and Microsoft 365 builds. Look for the equivalent commands under the Mailings tab: start a letter merge, select recipients, preview results and finish the merge by editing individual documents. VBA support and macro behavior also vary by platform, so the manual workflow may be the practical option on a system where the supplied macro cannot run.
Operational and privacy precautions
- Work from a copy of the template and retain the untouched original.
- Use a dedicated, access-controlled output directory because cover letters contain personal information.
- Do not email or upload the combined working document when individual delivery is the requirement; the combined file contains every recipient’s details.
- Delete temporary merged documents and intermediate files according to your organization’s retention policy.
- Keep a run record containing the source-list version, date, recipient range and output count if the letters form part of a regulated or auditable process.
Which method should you use?
For a recurring process, the VBA method provides repeatability, consistent naming and one export operation per record. It requires a macro-enabled workflow, a field suitable for filenames and permission to run VBA. For a one-time batch of a few recipients, editing the merged document and splitting it manually avoids macro setup and makes visual review straightforward. Whichever route you choose, validate the record count, page boundaries, recipient fields and filenames before distributing the PDFs.
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.
