Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Merging Labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dee - 11 Dec 2003 15:50 GMT
I am doing a label mail merge and when the merge is
complete and I review my labels there is a comma before
the city in the address. I looked at my data source and
there is no comma at the beginning of the city in my
spreadsheet. There is no comma in the labels with just the
fields. I am merging using excel as my data source. Would
anybody know why this is happening and how I can correct
it. I am using Word XP.

Thanks in advance for any help. By the way, you guys are
great. I have learned so much from the information you so
generously give through these newsgroups.

Happy Holidays!

Dee
Peter Jamieson - 11 Dec 2003 18:14 GMT
Are you using an ADDRESSBLOCK field to insert your data, or individual
fields?

If you are using an ADDRESSBLOCK field then use Alt-F9 to reveal what is
inside the ADDRESSBLOCK field. You will see something like

{ ADDRESSBLOCK blah
blah
blah
>><<_CITY_>><<, _STATE_>><< _POSTAL>>" blah }

What this means is

If the City is non-blank, insert it, otherwise insert nothing
If the State is non-blank, insert ", State", otherwise insert nothing
If the Postal code is non-blank, insert " Postal", otherwise insert nothing.

In other words, if your City is /blank/ but the State is non-blank, you will
see something like

, State Zip

which sounds very similar to what you are seeing. Now if what you are
actually seeing is a City name, then it may be because Word is "matching"
fields in a different way from what you expect (right-click on the Address
Block field, click the Edit option, click the Match fields button and have a
look). Or it may be because the data is not arriving in the expected
columns. - in my experience, that can happen if your Excel fields have
double-quote characters in them (e.g. in addresses or to denote "inches".).

/If/ that is what is happening, you will probably need to fix your data. Or
you could use individual fields rather than an address block. But that's a
bit more complicated...

--
Peter Jamieson - Word MVP

> I am doing a label mail merge and when the merge is
> complete and I review my labels there is a comma before
[quoted text clipped - 12 lines]
>
> Dee
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.