Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge has reached its data source limit?
In creating a large mail merge (data source has approx 700 columns) it
appears that it has reached it's limit - I cannot select the applicable columns after 600 odd from the insert merge field list. Apart from splitting the document into multiple files with multiple data sources is there any other solution? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge has reached its data source limit?
You could create a "roll-your-own" equivalent to mail merge that used
docvariable fields in place of merge fields and made use of VBA code to iterate through the datasource, setting the values of document variables to the values in each field of the current record and saved the document before moving on to the next record and doing the same thing. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "AndreVB" wrote in message ... In creating a large mail merge (data source has approx 700 columns) it appears that it has reached it's limit - I cannot select the applicable columns after 600 odd from the insert merge field list. Apart from splitting the document into multiple files with multiple data sources is there any other solution? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge has reached its data source limit?
Yes, there are problems in this area.
However, as long as Word is actually reading the data source correctly, you should be able to insert the merge fields "manually" as long as you know their names (i.e. instead of picking them from a list). For example, if the name is "my field", a. use ctrl-F9 to insert a pair of the special field code braces { } b. type MERGEFIELD "my field" so you end up with { MERGEFIELD "my field" } You only need the double-quotes for names that have, e.g., spaces in them. If it's "myfield" you only need { MERGEFIELD myfield } Otherwise, a. Apart from splitting the document into multiple files with multiple data sources Would that actually allow you to do what you need (in many cases, it would not solve the problem) b. what is the data source? c. what are you trying to create from it? Peter Jamieson http://tips.pjmsn.me.uk On 13/01/2010 02:21, AndreVB wrote: In creating a large mail merge (data source has approx 700 columns) it appears that it has reached it's limit - I cannot select the applicable columns after 600 odd from the insert merge field list. Apart from splitting the document into multiple files with multiple data sources is there any other solution? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
How do I move data Colums within the data source of a mail merge | Microsoft Word Help | |||
data in mail merge letter being cut off - data source field size? | Mailmerge | |||
How do I activate product key after limit is reached? | New Users |