Share via

MailMerge/Outline/Show Document/Create/Save Changes font in Saved File

Anonymous
2025-03-27T20:00:45+00:00

I am trying to have Word MailMerge save documents as separate files once the merge is complete. My source document is using the Calibri font and the resulting merged documents are using the Calibri font. In order to get Word to save the merge results as separate files:

  1. I have added a Header style to the top of the source document
  2. Saved the completed merged file, (with the Calibri font), to an empty folder
  3. Selected Outline on the View Tab
  4. Performed a CTL A to select the entire merged document
  5. Selected Show Document, all documents continue to show Calibri as the font.
  6. Selected “Create”, all document outlines continue to show Calibri as the font.
  7. Clicked on “Save”

As desired, each document in the merged document now has its own file in the folder. However somehow the font in each of the new Word files has changed to Aptos and the page spacing is now incorrect. I have changed the Normal.dotm template to Calibri for the “Normal” font and the problem continues. Somehow when the create/save step happens there is another template or default being used.

I have tried all sorts of variations all with the same results.

Is this operator error, an unchangeable limitation, or a bug?

Microsoft 365 and Office | Word | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

9 answers

Sort by: Most helpful
  1. Anonymous
    2025-03-31T15:09:19+00:00

    Thanks but that is definitely not true in my circumstance. When I click on "Create" in View/Show Documents" the document shown on the screen has the proper font but when I click on "save" the newly created documents are in Aptos. :(

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2025-03-28T16:31:05+00:00

    Thanks for your quick response! I have downloaded the add-on and will apply it. A feature of the "Outline" method that I liked was that by inserting multiple Header Styles into a single source document, the Create/Save will make a separate file for each Section. For my need, this can save a couple of steps. I don't think the Add-in can do that.

    Thanks again for your assistance.

    Steve

    PS. I still would love to know where the create/save is getting its Font Style from since it's not Normat.dotm!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2025-03-28T16:22:40+00:00

    Thank you for your quick response. Your Mailmerge Tips & Tricks is probably the most complete compilation of Word MailMerge information ever assembled! I look forward to not only using the section that applies to my current issue but using other sections in my future activities.

    Thanks again,

    Steve

    PS. I still would love to know where the create/save is getting its Font Style from since it's not Normat.dotm!

    Was this answer helpful?

    0 comments No comments
  4. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2025-03-27T22:56:40+00:00

    See Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks thread at:

    https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html

    Was this answer helpful?

    0 comments No comments
  5. Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
    2025-03-27T21:58:51+00:00

    Use the Merge to Individual Documents facility on my Merge Tools Add-in that is contained in the MERGE TOOLS ADD-IN.zip file that you can download from:

    https://mergetoolsaddin.com/

    Extract the files from the archive and read the:

    “READ ME – Setting up and using the Merge Tools Add-in.pdf

    to see how to install and use the various tools.

    Using those tools, it is possible to perform the following types of merge that cannot be done with Mail Merge “out-of-the-box”:

    • Merge to e-mail messages either with or without attachments, with the documents created by the merge being sent as either Word or PDF attachments or as the body of the e-mail message .  The email messages can, if necessary, also be sent to CC and BCC addresses and the subject of the message can include data from a field in the data source.
    • Merge to individual documents in either Word or PDF format with the filenames being supplied by the data in one of the fields in the data source
    • Many to One type merges, which can be used for creating documents such as invoices where there are multiple records in the data source that have common data in one of the fields
    • Merging to a document that will include a chart that is unique to each record in the data source
    • Merging a document with Content Controls
    • Merging a document that contains Legacy FormFields
    • Duplex Merges
    • Merging to a printer that will collate and staple the output created from each record in the data source.

    The requirements for using the system are:

    • The mail merge main document must be of the Letters type, though that does not mean that the output cannot be sent as an e-mail message where relevant.
    • For the Many To One, Merge with Attachments and Merge to Individual Docs utilities, the data source may be either a table or query in an Access database, or in the form of an Excel worksheet. For the Chart Merge utility, see the Mail Merging with Charts document that is included in the Merge Tools Add-in Zip file for additional requirements for the data source for use with that utility
    • For a data source in the form of an Excel worksheet, the field names must be in the first row of the worksheet and there must be a field name in all of the cells in that row that are within the range of columns that contain the data.
    • For both types of data source, the field names must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9). The number of characters in the field names, including spaces, must not be more than 40.

    The MergeTools Add-in will NOT work with the “New Outlook”, which is just a re-badged version of Windows Mail and like its predecessor, it does not support automation and hence will not send the messages created by the MergeTools Add-in.

    Be aware, that any messages that you had tried to send with the “New Outlook” will have been placed in the Outbox of the original Outlook and they will be sent as soon as you revert to that version of Outlook.   If you do not want that to happen, you should put Outlook Off-line, or disconnect your computer from the Internet.

    For a demonstration of the use of the facility, prepared by a Microsoft employee, see

    https://www.youtube.com/watch?v=yj_s3cdfVDY

    Was this answer helpful?

    0 comments No comments