City, State, Zip Line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angie - 18 Nov 2004 19:46 GMT

I am merging data from EXCEL into word to print labels.
I have separate fields for City, State, & Zip. On some
of the labels they are printing fine, but on some labels
it prints city with several spaces before the ,ST & Zip.
This causes it to print the Zip code on a separate line.
I don't know why it is printing spaces after the city
sometimes, but not always.

Any help would be appreciated.

Reply to this Message

Doug Robbins - 19 Nov 2004 02:56 GMT

Probably because there are spaces after the City name in some of the
records. Excel has rudimentary Edit>Replace capability that you may be able
to use to remove the superfluous spaces or use a catalog type mailmerge to
get all of the data in a Word table and used the more capable Edit>Replace
features in Word. Then insert a row at the top of the table to hold the
field names and save and use that document as the datasource.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am merging data from EXCEL into word to print labels.
> I have separate fields for City, State, & Zip. On some
[quoted text clipped - 5 lines]
>
> Any help would be appreciated.

Reply to this Message