Thread: Blank fields
View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
oe
 
Posts: n/a
Default Blank fields

I still seem to have something wrong here.

I have

Title Initial . Last_Name

One of my addressees is J Smith

Whatever I try, I get a blank space before the "J"

"Charles Kenyon" wrote in
message ...
Doug Robbins' answer covers it.

Try help under "If field." Click on examples.

{ If Test1 = "" "" "Test1 " }

This checks the value of the bookmark Test1. If it is empty, nothing is
inserted, otherwise if it is not empty, Test1 followed by a space is
inserted. You would insert your merge field in place of Test1 in both
places.
--
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.

"oe" wrote in message
...
I seem to have trouble merging when the first one or two mergefields are
blank, e.g.

Title Initial . Last_Name

If Title is blank, I want to enter Initial but without a blank space at
the beginning; if there is nothing in the Title or Initial fields, I want
just the last name - again without any blanks. It should look something
like
Title: Mr (or blank space)
Initial: A (or blank space)
Last_Name (two blank spaces) Famille Dupont

Not sure if I've explained that very well!
Thanks for your help.

"Doug Robbins - Word MVP" wrote in message
...
If a field is empty or blank, it will be equal to "" in an
If...then....Else field construction.

Is there anything else that you need to know about it?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"oe" wrote in message
...
Can someone please point me in the direction of help understanding the
Null fields, e.g. "" " so that I can work out If..Else..statements,
etc - this does not appear to be covered in Help for Word 2003

TIA