Check your record 2706 for errors e.g. an unwanted comma or quote.
If you use ALT+F9 to toggle the entries on your label layout, you should see
{ MERGEFIELD Contact }
{ MERGEFIELD Company }
{ MERGEFIELD Address_1 }
{ MERGEFIELD Address_2 }
{ MERGEFIELD Address_3 }
{ MERGEFIELD Address_4 }
{ MERGEFIELD Address_5 }
{ MERGEFIELD Address_6 }
{ MERGEFIELD Postcode }
Edit that to give
{ MERGEFIELD Contact }¶
{ MERGEFIELD Company }¶
{ MERGEFIELD Address_1 }¶
{ MERGEFIELD Address_2 }¶
{ MERGEFIELD Address_3 }¶
{ MERGEFIELD Address_4 }{ IF { MERGEFIELD Address_5 } <> "" "{ IF {
MERGEFIELD Address_5 } <> "0" "¶
{MERGEFIELD Address_5}" "" }" ""}{ IF { MERGEFIELD Address_6 } <> "" "{
IF{ MERGEFIELD Address_6 } <> "0" "¶
{ MERGEFIELD Address_6 }" "" }" ""}¶
{ MERGEFIELD Postcode }¶
Using CTRL+F9 for the brackets {} and press enter only where you see ¶
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
DvDj wrote:
[Quoted Text] > I have a database of customers in the form of an excel spreadsheet > consisting of 2707 entries. For some reason everything after 2705 > are being ignored within my mailmerge. Is Word (2007) limited to a > certain number? > > Secondly i have a label layed out in the following way. > > <<Contact>> > <<Company>> > <<Address_1>> > <<Address_2>> > <<Address_3>> > <<Address_4>> > <<Address_5>> > <<Address_6>> > <<Postcode>> > > Fields Address_5 and Address_6 are often blank and sometimes are > filled with a zero (that arent in the spreadsheet). I have tried > writting my own mergefield rules wich resulted in the zeroes > correctly being wiped out but also Address_5 and Address_6!!!! If > possible I would also like to have the Postcode move up just below > Address_4 If 5 & 6 are blank. > > Hope that all makes sense, heres hoping theres a solution. > > Many thanks
|