Lists in Mail Merge

D

DivaahMom

I did a letter in Word which had a list numbered 1-8. When I initially merged
the document with an Excel file it worked perfectly - each letter had a 1-8
list. Also, as I was editing the output and going in and out of the documents
(i actually had 9 variations) I had no problem. Today, when I opened the
documents the lists had become one continuous list rather than 1-8 on each
page. Ex - the list on the document which had 30 pages - the list on page 2
was 9-16 and so forth until on the last page the last item was 240.

When I re-merged the document again it was fine - but I want to save the
merged document in its original format. This is a contract and I can't keep
re-merging. I am sure that there is something that I need to do in the merge
document. Please help!
 
D

Doug Robbins - Word MVP

Before executing the merge, run a macro on the mail merge main document that
contains the following command:

ActiveDocument.ConvertNumbersToText

That will convert the numbers 1 - 8 in your numbered list to ordinary text.

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top