mail merge - not showing all data

[Joyce]

Back in 2006 Mech73 wrote the following:
Trying to do a labels mail merge in 'new' MS Word '03, using XL as my data
source, but it's only recognising the first 16 items and totally ignoring
the next 18...and this is only a trial run for 550! (That is, only showing 16
items in the "Edit recipients list".)

Doug Robbins provided the following website to help:
See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham
Mayor's website at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

I'm having a similar problem but in Word 2007. I went to the above article
and used the solution suggested there. It worked for the first data source
that I tried (showed all 4 records instead of 1) but when I tried the data
source with 8 records it only showed me 4 records. The unique identifier of
the data source is a number formatted as text so it reads as '123.4 instead
of 123.4 but this used to work fine in the past it has just started playing
up within the last week. The data source is an Excel file in compatibility
mode so it has a .xls extension. All the merge field names are spelt the
same in all data sources. It is just the data that changes.

Is there anyone who can help me?

 

[Doug Robbins - Word MVP]

I am not sure what the unique number of the data source has to do with
things, but are you actually executing the merge? How many labels are there
on the sheet?

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

 

[Joyce]

Hi Doug,
It's actually a form letter and we haven't executed it as when we look at
the recipients under "Edit recipients list" there are some missing. The
weird thing is, if we copy the data to a new spreadsheet and then attempt the
mail merge, we get all the records showing under "Edit recipients list"
without any problems.
It is a weird problem.