Mail Merge - numbered list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jus - 23 May 2008 16:31 GMT

I am merging a document. The last item on the document is item number 32 on a
numbered list. I can merge and print with no problem. However, when I edit
individual letters and save - the final saved/merged document sequentually
numbers each page as if it was a continuation from the previous.

In other words - the first merged letter ends at number 32 and the next
merged letter starts numbering the list at 33 and so on.

Each letter should have a numbered list 1 through 32, but instead, the last
letter numbered list ends with 500+

Any ideas?

Reply to this Message

Doug Robbins - Word MVP - 24 May 2008 00:51 GMT

What type of numbering are you using? What version of Word? I cannot
replicate that problem using a numbered list in Word 2007.

Signature

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

>I am merging a document. The last item on the document is item number 32 on
>a
[quoted text clipped - 10 lines]
>
> Any ideas?

Reply to this Message

jus - 28 May 2008 16:39 GMT

Word 2007

I am merging answers to a series of questions -

Each record from the spreadsheet has identifying info (name, address) as
well as answers to 32 questions.

The document has questions 1-32 (numbered list)

The actual question #1 is on the document and I merge the answer from an
Excel 2007 spreadsheet.

merge is fine - each merged record accurately represents identifying info
and answers to questions 1 through 32.

There is no problem if I print the fully merged document.

Problem is when I save the fully-merged document. When I open the
saved/merged document, each record is there but the questions are now
numbered sequentially without any break between each record.

for example -
record#1....John Doe with questions 1 through 32
record#2....Jane Smith with questions 33-55 - and so on.

FYI - apparently the same thing happened with Word 2003 as well.

> What type of numbering are you using? What version of Word? I cannot
> replicate that problem using a numbered list in Word 2007.
[quoted text clipped - 13 lines]
> >
> > Any ideas?

Reply to this Message

Doug Robbins - Word MVP - 28 May 2008 20:34 GMT

With the mail merge main document as the active document, run a macro
containing the command

ActiveDocument.ConvertNumbersToText

to convert the numbers in the numbered list to ordinary text.

Signature

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

> Word 2007
>
[quoted text clipped - 43 lines]
>> >
>> > Any ideas?

Reply to this Message

jus - 30 May 2008 15:31 GMT

Wow! Thanks Doug, it worked like a charm.

> With the mail merge main document as the active document, run a macro
> containing the command
[quoted text clipped - 50 lines]
> >> >
> >> > Any ideas?

Reply to this Message