missing field creates a space when printing labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BikerK - 09 Nov 2005 20:09 GMT

Some names in my data source do not have a title field. Their records show a
space when printing on labels. How can I remove this blank space?

Reply to this Message

Charles Kenyon - 09 Nov 2005 20:28 GMT

You need to use an IF field to control the space. { IF <<TITLE>> <> "" " "}
You can do this with the Merge toolbar Merge Fields.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ 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.

> Some names in my data source do not have a title field. Their records
> show a
> space when printing on labels. How can I remove this blank space?

Reply to this Message

macropod - 09 Nov 2005 21:57 GMT

If you copy and paste your existing mailmerge field, which probably looks
something
like:
«Title»
so that you've got:
«Title»«Title»
then select both fields and Press Ctrl-F9, you'll get:
{ «Title»«Title» }
If you then fill in between the braces so that you've got:
{IF«Title»= "" "" "«Title» "}
and delete the space(s) after the existing «Title» field, that should give
the result you're after.

Cheers

> Some names in my data source do not have a title field. Their records show a
> space when printing on labels. How can I remove this blank space?

Reply to this Message