How to increase fields for mail merge?

I am using Word 2007 that I am trying to merge in more than 256 data fields from an excel 2007 file. Please give me a way without CSV format.

You could use Merge to Individual Documents facility on the MergeTools – 20140218 Add-in that I created that you can download from the following page of my One Drive\Windows Live SkyDrive:

https://onedrive.live.com/?cid=5aedcb43615e886b#cid=5AEDCB43615E886B&id=5AEDCB43615E886B%21566

https://skydrive.live.com/?cid=5aedcb43615e886b#!/?cid=5AEDCB43615E886B!cid=5AEDCB43615E886B&id=5AEDCB43615E886B%21566

Save the file in the Word Startup folder.  In Windows XP the default location for that folder is

C:\Documents and Settings\[User Name]\Application Data\Microsoft\Word\STARTUP

In Windows Vista and Windows 7, it is

C:\Users\[User Name]\AppData\Roaming\Microsoft\Word\STARTUP

When you have done that, the tab shown below will be added to the Ribbon:



One thing to note is that the field names in your data source must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9).

The facility is designed to be used with a Letter type mail merge main document to which you attach and Excel data source.  To insert "mergefields" that appear in the data source after the 255th field, you will need to use Ctrl+F9 to insert a pair of field delimiters, inside of which you enter MERGEFIELD "fieldname"

{ MERGEFIELD "fieldname"}

Use Alt+F9 to toggle off the display of the field codes.

Note also that you will not be able to preview the results of those fields as Mail Merge itself will not recognise them.  Do not even try to preview the results as it will cause an error.

As it stands, the facility, which does not actually use mail merge, will allow you to execute the "merge" to individual Word documents or to PDF documents and for that purpose, the datasource will need to contain a field that contains data that is unique for each record that can be used a the filename for saving the document.

It could be modified to execute the "merge" to a printer.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

An alternative is to review why you have so many data fields. That can sometimes be the result of faulty assumptions about what needs to be in the data fields and what can be handled by field coding within the mailmerge main document. If, for example, some data fields are just holding variable text, it might be possible to reduce some of these to a single field and/or use one or more IF fields in the document to add logic that determines the text to be output in each case.
Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 30, 2025 Views 1,166 Applies to: