Share via

How do you manually enter a merge field. And i am not asking about using the helper drop down.

Anonymous
2023-09-07T23:33:08+00:00

Okay I've got a good one for you. How do you manually enter merge items. Maybe many are unaware but the helper drop down has a limitation of 255 fields so if you have added a list of say 1500 fields those beyond 255 cant not be added via drop down. So how can we manually enter a field that we know is in there?

MS pages say to use the database fields but that still only shows 255 fields.

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

5 answers

Sort by: Most helpful
  1. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2023-09-08T04:25:16+00:00

    Use Ctrl+A to select everything in the document and then press F9 to update the fields. You should then see the «fieldname»

    Alternatively download the Formatted MergeFields Add-in from the following page of my OneDrive. has no limit to the number of fields that it can handle.

    Miscellaneous Merge Tools

    2 people found this answer helpful.
    0 comments No comments
  2. Jay Freedman 207.6K Reputation points Volunteer Moderator
    2023-09-07T23:54:25+00:00

    If you start by inserting a couple of merge fields through the Insert Merge Field dropdown to get something like this:

    Image

    Image

    .

    You can reverse that process, using Ctrl+F9 to create a field and typing the MERGEFIELD keyword followed by the name of the data column in the source. I found that I had to update the field to make it appear when pressing Alt+F9 again to collapse the codes. The manually created merge fields receive the proper data from the source.

    I have to ask, though: What are you doing that requires more than 255 distinct data items, let alone 1500?

    https://learn-attachment.microsoft.com/api/attachments/aa3936f7-e90e-426b-864f-1705b808d500?platform=QnA

  3. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2023-09-09T10:20:31+00:00

    Word in Microsoft 365 Apps for enterprise will only display the first 256 fields in the dropdown.

    There is however no limit with my Add-in which can display all of the 16,384 fields that can be accommodated in Excel.

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2023-09-08T23:51:04+00:00

    Yeah for me i will test your add-in but you know im not really gonna be able to suggest this to clients. Although the client did find that word 365 will display upto 1000 fields in the drop down.

    0 comments No comments
  5. Anonymous
    2023-09-08T00:43:26+00:00

    I work for a piece of software used in court systems and one of our tools has about 1500 tokens. We use the mail merge with a custom list of tokens the program replaces the mail merge tokens with data. I am rather new and don't think our devs know of the 255 field limitation. Our other tool only has like 100 fields but this one program has 1500 and of course customers will want to add ones they cant see so I need to determine how to add them manually as well as test that anything beyond 255 is actually able to be used and was loaded which i think it is from my research just the helper is severly limited.

    And hmm yeah i can see how that should work. I noted also if you hit ctrl+f9 on the page it makes {} ie so you can type yours in, but if I fill it in and then unf9 it goes blank doesn't leave me with <<whatever>> as i expect i can toggle the field again to see what i had previously typed which i think this is the manual method but theres something missing or not really working.

    So here's the manual method ive noted that isnt workign quite right.

    place cursor on page press ctrl+f9 you will get a highlighted {}

    type in I gather mergefield "whatver" then click away from where you type then right click toggle field codes and what you typed vanishes i expect it to be replaced with "whatever" but it's not it's just there blank

    Tested it with blank and it does work so thats how to as it manually above just it wont display the<<whatever>> as one expects to see

    0 comments No comments