I have Word 2003 and an Excel file with zip codes as a field. I want it to
"break" at every zip code like this:
-------
85615
-------
entry with this zip code
entry with this zip code
entry with this zip code
entry with this zip code
entry with this zip code
-------
85711
-------
entry with this zip code
entry with this zip code
entry with this zip code
entry with this zip code
The syntax I have in the merge document is like this:
{ IF {MERGESEQ} = "1" "{SellerZip}
" ""} {SET Place1 {SellerZip}}
{IF {Place2}<>{Place1}"
{SellerZip}
{SellerName} {SellerAddress} {SellerCityState}; ${SaleAmount}" "{SellerName}
{SellerAddress}
{SellerCityState}; ${SaleAmount} " }
{SET Place2{SellerZip} }
Obviously it should break at "seller zip."
I get an "Error! Bookmark not defined" message; it looks like this:
COELHO MARIO & BONNIE L CP/RS Error! Bookmark not defined. Error! Bookmark
not defined. ; Error! Bookmark not defined.; 925000
It seems to do it immediately after "SellerName" if I have it right.
Regardless it does seem to merge the data properly regardless, but this
error concerns me.
Tips?
LRH
Larry,
The code should look like this:
{ IF {MERGESEQ} = "1" "{MERGEFIELD "SellerZip"}
" ""} {SET Place1 {MERGEFIELD "SellerZip"}}
{IF {Place2}<>{Place1}"
{MERGEFIELD "SellerZip"}
{MERGEFIELD "SellerName"} {MERGEFIELD "SellerAddress"} {MERGEFIELD
"SellerCityState"}; ${MERGEFIELD "SaleAmount}" "{MERGEFIELD "SellerName"}
{MERGEFIELD "SellerAddress"} {MERGEFIELD "SellerCityState"}; ${MERGEFIELD
"SaleAmount"} " }
{SET Place2{MERGEFIELD "SellerZip"} }

Signature
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
>I have Word 2003 and an Excel file with zip codes as a field. I want it to
> "break" at every zip code like this:
[quoted text clipped - 44 lines]
>
> LRH
Larry R Harrison Jr - 17 Mar 2004 18:22 GMT
Thanks, that worked great.
Wish there were some way to literally copy & paste it, though; the brackets
in here aren't the same CTRL-F9 word uses to denote merge fields, otherwise
you could do a flat-out copy & paste. Oh well.
Thanks.
LRH
> Larry,
>
[quoted text clipped - 66 lines]
> >
> > LRH