Break-Points in ZIP Code Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry R Harrison Jr - 10 Mar 2004 23:39 GMT

I have a mail-merge document setup which links to an Excel file. I have it
working fine for the most part, except for this: I need it to break-up the
data in zip codes, where the zip codes change. It already sorts by zips, but
it also needs to separate them, like so:

=====
85614
=====
entries applying to this zip
,,
,,
,,
,,

=====
85711
=====
entries applying to this zip
,,
,,
,,
,,

Tips?

LRH

Reply to this Message

Graham Mayor - 11 Mar 2004 05:11 GMT

See Microsoft Knowledge base article KB294686
HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2002
http://support.microsoft.com/?kbid=294686

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have a mail-merge document setup which links to an Excel file. I
> have it working fine for the most part, except for this: I need it to
[quoted text clipped - 22 lines]
>
> LRH

Reply to this Message

Larry R Harrison Jr - 11 Mar 2004 16:55 GMT

I've tried it numerous times, I can't even BEGIN to figure that out, not
even in my wildest dreams.

Any other tips? Step-by-step instructions? That thing is HAAAAAAAAAAARD.

LRH

> See Microsoft Knowledge base article KB294686
> HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2002
[quoted text clipped - 34 lines]
> >
> > LRH

Reply to this Message

Larry R Harrison Jr - 11 Mar 2004 18:28 GMT

Sorry for pressing the panic button. I bit of persistence seemed to do it.

The syntax in the template is:

{ IF {MERGESEQ} = "1" "{TenZIP}
" ""} {SET Place1 {TenZIP}}
{IF {Place2}<>{Place1}"
{TenZIP}

{Tenant} {TenAddr} {TenCityState}; ${PropValue}" "{Tenant} {TenAddr}
{TenCityState}; ${PropValue} " }
{SET Place2{TenZIP} }

Of course you use CTRL-F9 to generate the pair of brackets and if you open
the document up later and the codes seem gone, ALT-F9 brings them back.

Thanks anyway, and thanks for the links.

LRH

> I've tried it numerous times, I can't even BEGIN to figure that out, not
> even in my wildest dreams.
[quoted text clipped - 41 lines]
> > >
> > > LRH

Reply to this Message

Charles Kenyon - 11 Mar 2004 16:38 GMT

See <URL:
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg>.

Signature

Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> I have a mail-merge document setup which links to an Excel file. I have it
> working fine for the most part, except for this: I need it to break-up the
[quoted text clipped - 22 lines]
>
> LRH

Reply to this Message

Rate this thread: