How do I remove a comma after company name in mail merge address.

C

Cressida123

I am try to complete a mail merge document. I am having trouble removing the
comma that is added automatically after the company name in the address
block. Is it possible to remove it before completing the merge?
 
P

Peter Jamieson

Are you sure the comma is added by the AddressBlock field? No comma is added
here.

1. If the problem is in the Addressblock, you have two options:
a. check the addressblock to ensure that no comma is inserted by the
addressblock code
b. do not use the Addressblock - use the individual fields instead.

For (a), if you press Alt-F9 to view the "underlying" ADDRESSBLOCK field,
you will see something roughly like:

_COUNTRY_>>" \l 2057 \c 2 \e "United Kingdom" }

As far as I know, Addressblock would only insert a comma if you (or whoever
created the merge document) had put one somewhere in that text, e.g. if you
had one at the end of the COMPANY line:

<<_COMPANY_,
(If you are in the U.S.A., there is likely to be a comma between _CITY_ and
_STATE_, but I do not think that would result in the problem you are seeing.
But perhaps one is inserted in the ADDRESSBLOCK generated for some locales).

Whenever you "edit" the ADDRESSBLOCK layout in the Addressblock dialog box,
Word completely recreates the ADDRESSBLOCK code so any such comma should
either disappear (if it was added manually) or reappear (if Word thinks it
should be there). In the latter case you would need to remove it again each
time you edited the addressblock layout.

2. Much more likely is that the comma is there in the data, in which case it
will be harder to remove. (If the amount of data is not large and only used
for this merge, it will probably be easiest to remove the comma manually in
the data source).
 
G

Graham Mayor

You might find it a lot simpler to abandon the AddressBlock and use the
individual address fields laid out as you require them.

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Joined
Nov 7, 2013
Messages
1
Reaction score
0
I am try to complete a mail merge document. I am having trouble removing the
comma that is added automatically after the company name in the address
block. Is it possible to remove it before completing the merge?

I fussed with the same problem for a long time. Finally, I used find and replace. I put the comma in the find and replaced it with nothing. It actually worked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top