View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Joyce Joyce is offline
external usenet poster
 
Posts: 32
Default mail merge - not showing all data

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_lab...th_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?
--
Joyce