Mergefield issue and is merge limited to a certain number?

D

DvDj

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
 
G

Graham Mayor

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