Mail merge to directory does not reset numbering in document

[Millieac]

I created a merge document that has multilevel numbering in it. When I do a
merge to directory, every record needs to retain that numbering sequence.
However, the merged document does not reset the numbering for every record,
so instead of having 50 records with format from 1-5 for the merge fields, I
have a numbering scheme in the final document of 1-250.

[Doug Robbins - Word MVP]

As the result of a directory type mail merge does not insert a Section break
between the data for each record, there is nothing that can be used to
trigger a restart of the numbering.

The only way I could see to get what you want is to use keyed-in numbers for
the 1, 2, 3, 4 and 5 rather than using multi-level numbering.

--
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, originally posted via msnews.microsoft.com

"Millieac" <Mill...@discussions.microsoft.com> wrote in message
news:272BE459-FBA0-47DF...@microsoft.com...

[macropod]

Hi Millieac,

If the records are in groups of 5, you could use a formula field coded as:
{=MOD({SEQ Counter},5)+1}
To output this as plain text, simply code the field as:
{QUOTE{=MOD({SEQ Counter},5)+1}}

--
Cheers
macropod
[Microsoft MVP - Word]

"Millieac" <Mill...@discussions.microsoft.com> wrote in message news:272BE459-FBA0-47DF...@microsoft.com...

[Jenn Walcott]

Mail merge to directory does not reset numbering in documentMillieac posted on Thursday, April 15, 2010 4:01 PM

I created a merge document that has multilevel numbering in it. When I do a merge to directory, every record needs to retain that numbering sequence.
However, the merged document does not reset the numbering for every record, so instead of having 50 records with format from 1-5 for the merge fields, I
have a numbering scheme in the final document of 1-250.

Hi, I am looking for the reply to the above post last year. I have exactly the same problem. I had a 2 page document to be merged with an excel database list, that on page 1 had a list of 3 numbered items. i.e. 1, 2 & 3

However when the document merged every letter following the first increased the numbering sequence in the letters, so for the next person to get the letter the numbers on the first page became 3, 4 & 6 and the third person 7, 8 & 9 and so on.

I was wondering what the reply was to that persons question last year. I tried using Word 2007 "help" but couldn't find an answer, or perhaps I just worded my question incorrectly. Anyhow, hoping someone can help me with this. Thanx in advance for your assistance.

>> On Thursday, April 15, 2010 5:01 PM Doug Robbins - Word MVP wrote:

>> As the result of a directory type mail merge does not insert a Section break
>> between the data for each record, there is nothing that can be used to
>> trigger a restart of the numbering.
>>
>> The only way I could see to get what you want is to use keyed-in numbers for
>> the 1, 2, 3, 4 and 5 rather than using multi-level numbering.
>>
>> --
>> 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, originally posted via msnews.microsoft.com

[Dean Stonehocker]

There's actually a much simpler solution to this. I had the same problem just now, and I solved it by putting a continuous section break at the end of my document before completing the merge. You could use a "new page" section break, but that creates a blank page at the end of each document.

> On Thursday, April 15, 2010 4:01 PM Millieac wrote:

>> On Thursday, April 15, 2010 5:01 PM Doug Robbins - Word MVP wrote:

>> As the result of a directory type mail merge does not insert a Section break
>> between the data for each record, there is nothing that can be used to
>> trigger a restart of the numbering.
>>
>> The only way I could see to get what you want is to use keyed-in numbers for
>> the 1, 2, 3, 4 and 5 rather than using multi-level numbering.
>>
>> --
>> 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, originally posted via msnews.microsoft.com


>>> On Thursday, April 15, 2010 6:32 PM macropod wrote:

>>> Hi Millieac,
>>>
>>> If the records are in groups of 5, you could use a formula field coded as:
>>> {=MOD({SEQ Counter},5)+1}
>>> To output this as plain text, simply code the field as:
>>> {QUOTE{=MOD({SEQ Counter},5)+1}}
>>>
>>>
>>> --
>>> Cheers
>>> macropod
>>> [Microsoft MVP - Word]

>>>> On Tuesday, March 29, 2011 1:52 AM Jenn Walcott wrote:

>>>> Mail merge to directory does not reset numbering in documentMillieac posted on Thursday, April 15, 2010 4:01 PM
>>>>

>>>> I created a merge document that has multilevel numbering in it. When I do a merge to directory, every record needs to retain that numbering sequence.
>>>>
>>>> However, the merged document does not reset the numbering for every record, so instead of having 50 records with format from 1-5 for the merge fields, I
>>>>
>>>> have a numbering scheme in the final document of 1-250.
>>>>
>>>>
>>>>

[kiwi...@clear.net.nz]

On Tuesday, 20 December 2011 08:08:31 UTC+13, Dean Stonehocker wrote: > There's actually a much simpler solution to this. I had the same problem just now, and I solved it by putting a continuous section break at the end of my document before completing the merge. You could use a "new page" section break, but that creates a blank page at the end of each document. > On Thursday, April 15, 2010 4:01 PM Millieac wrote: > I created a merge document that has multilevel numbering in it. When I do a > merge to directory, every record needs to retain that numbering sequence. > However, the merged document does not reset the numbering for every record, > so instead of having 50 records with format from 1-5 for the merge fields, I > have a numbering scheme in the final document of 1-250. >> On Thursday, April 15, 2010 5:01 PM Doug Robbins - Word MVP wrote: >> As the result of a directory type mail merge does not insert a Section break >> between the data for each record, there is nothing that can be used to >> trigger a restart of the numbering. >> >> The only way I could see to get what you want is to use keyed-in numbers for >> the 1, 2, 3, 4 and 5 rather than using multi-level numbering. >> >> -- >> 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, originally posted via msnews.microsoft.com >>> On Thursday, April 15, 2010 6:32 PM macropod wrote: >>> Hi Millieac, >>> >>> If the records are in groups of 5, you could use a formula field coded as: >>> {=MOD({SEQ Counter},5)+1} >>> To output this as plain text, simply code the field as: >>> {QUOTE{=MOD({SEQ Counter},5)+1}} >>> >>> >>> -- >>> Cheers >>> macropod >>> [Microsoft MVP - Word] >>>> On Tuesday, March 29, 2011 1:52 AM Jenn Walcott wrote: >>>> Mail merge to directory does not reset numbering in documentMillieac posted on Thursday, April 15, 2010 4:01 PM >>>> >>>> I created a merge document that has multilevel numbering in it. When I do a merge to directory, every record needs to retain that numbering sequence. >>>> >>>> However, the merged document does not reset the numbering for every record, so instead of having 50 records with format from 1-5 for the merge fields, I >>>> >>>> have a numbering scheme in the final document of 1-250. >>>> >>>> >>>> >>>> Hi, I am looking for the reply to the above post last year. I have exactly the same problem. I had a 2 page document to be merged with an excel database list, that on page 1 had a list of 3 numbered items. i.e. 1, 2 & 3 >>>> >>>> >>>> >>>> However when the document merged every letter following the first increased the numbering sequence in the letters, so for the next person to get the letter the numbers on the first page became 3, 4 & 6 and the third person 7, 8 & 9 and so on. >>>> >>>> >>>> >>>> I was wondering what the reply was to that persons question last year. I tried using Word 2007 "help" but couldn't find an answer, or perhaps I just worded my question incorrectly. Anyhow, hoping someone can help me with this. Thanx in advance for your assistance.

[Lisa Wilke-Thissen]

Hi,

what do you want to tell us? Unfortunately, your text below is hard to
understand...

--
Cheers,
Lisa