Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge nightmares
Can anyone explain what is happening here -
I've got a 5 cell table, including a first item of data and 4 "next records" linked to an excel sheet with 100 records in it. When I click the button to "merge to new document", I can see in the status bar it seems to be processing 100's of records even though in the mail merge doc I've only linked to 5. This is causing problems when I put 100 next records in the main doc, and merge to new, its getting corrupt tables everywhere what I'd like to know is how I can find out what "merge to new doc" is doing, where it's getting its info from and why, when the main doc is a 5 column by 1 row table is the "merge to new" creating a 10 page document like it's trying to read the whole excel file but not properly displaying them all |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge nightmares
Exactly what do you have in the table in the mail merge main document?
Particularly after the "next records" fields? Is the only mergefield the one in the first row? What exactly are you trying to produce? Give us an example of what the finished product is supposed to be and how the data is arranged. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Lee Harris" wrote in message ... Can anyone explain what is happening here - I've got a 5 cell table, including a first item of data and 4 "next records" linked to an excel sheet with 100 records in it. When I click the button to "merge to new document", I can see in the status bar it seems to be processing 100's of records even though in the mail merge doc I've only linked to 5. This is causing problems when I put 100 next records in the main doc, and merge to new, its getting corrupt tables everywhere what I'd like to know is how I can find out what "merge to new doc" is doing, where it's getting its info from and why, when the main doc is a 5 column by 1 row table is the "merge to new" creating a 10 page document like it's trying to read the whole excel file but not properly displaying them all |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge nightmares
How have you linked this to only five records?
What on earth is the purpose of 100 'next record' fields? What is the document type? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lee Harris wrote: Can anyone explain what is happening here - I've got a 5 cell table, including a first item of data and 4 "next records" linked to an excel sheet with 100 records in it. When I click the button to "merge to new document", I can see in the status bar it seems to be processing 100's of records even though in the mail merge doc I've only linked to 5. This is causing problems when I put 100 next records in the main doc, and merge to new, its getting corrupt tables everywhere what I'd like to know is how I can find out what "merge to new doc" is doing, where it's getting its info from and why, when the main doc is a 5 column by 1 row table is the "merge to new" creating a 10 page document like it's trying to read the whole excel file but not properly displaying them all |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge nightmares
Just a bit of explanation in addition to what the others have said:
When you merge to a new document, Word (in effect) a. creates a new document b. starts with the first record in the data source c. creates a copy of the mail merge main document and starts filling in MERGEFIELD and other fields from the data in that record. If it encounters a Next record field ({ NEXT } field) then it simply starts taking data from the next record in the data source. d. appends the filled-in copy to the new document e. moves to the next record in the data source and repeats (b) to (d), until there are no records left. For example, if you have 5 Next record fields in your mail merge main document, Word will start with record 1, then for the next pass through the mail merge main document, it will already have "consumed" records 2,3,4,5 and 6 and will start with 7. Word also does special stuff with "NEXTIF" and "SKIPIF" fields, and takes account of the start and end records you specify, and any selections you may also have specified If the Mail Merge type is "Letters" (Form letters), Word outputs a section break after each pass through the mail merge main document. if the type is "Directory" (also called "Catalog"), Word does not add any breaks. (Well, that is the overall effect, anyway). When people first start using merge, I suspect it is quite common to get confused about what Next record and the NEXTIF/SKIPIF stuff actually do, partly because most people probably start using them to try to perform a merge that processes "multiple items per record", and merge isn't really quite up to that task. Peter Jamieson "Lee Harris" wrote in message ... Can anyone explain what is happening here - I've got a 5 cell table, including a first item of data and 4 "next records" linked to an excel sheet with 100 records in it. When I click the button to "merge to new document", I can see in the status bar it seems to be processing 100's of records even though in the mail merge doc I've only linked to 5. This is causing problems when I put 100 next records in the main doc, and merge to new, its getting corrupt tables everywhere what I'd like to know is how I can find out what "merge to new doc" is doing, where it's getting its info from and why, when the main doc is a 5 column by 1 row table is the "merge to new" creating a 10 page document like it's trying to read the whole excel file but not properly displaying them all |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word crashes when I try to mail merge using Outlook recipients | Mailmerge | |||
Mail Merge insert merge fields | Mailmerge | |||
Mail Merge | Mailmerge | |||
Heavy Mail Merge Application | Mailmerge | |||
How to get all mail merge fields in a document | Mailmerge |