 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2005Blank fields
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 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?  SignatureHope 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 > 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 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. > If a field is empty or blank, it will be equal to "" in an > If...then....Else field construction. [quoted text clipped - 6 lines] >> >> TIA Can anyone help with this problem, please? >I seem to have trouble merging when the first one or two mergefields are >blank, e.g. [quoted text clipped - 22 lines] >>> >>> TIA 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. SignatureCharles 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. >I seem to have trouble merging when the first one or two mergefields are >blank, e.g. [quoted text clipped - 22 lines] >>> >>> TIA 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" > Doug Robbins' answer covers it. > [quoted text clipped - 32 lines] >>>> >>>> TIA {IF {Mergefield Title} <> "" "{Mergefield Title} "}{Mergefield Initial}. {Mergefield Last_Name} ie {IF {Mergefield Title}space<>space""space"{Mergefield Title}space"}{Mergefield Initial}.space{Mergefield Last_Name} Should do it. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I still seem to have something wrong here. > [quoted text clipped - 63 lines] >>>>> If..Else..statements, etc - this does not appear to be covered in >>>>> Help for Word 2003 TIA Just a simple thought but, Have you tried turning on the paragraph format characters, that big weird P button, while field names are displayed, to make sure there isn't a rogue space between each merge field? Signaturemasterkeys Thanks -that works fine! > Just a simple thought but, > > Have you tried turning on the paragraph format characters, that big > weird P button, while field names are displayed, to make sure there > isn't a rogue space between each merge field? You would still get a space attributable to the space following the missing Title field. You could manually remove this from the merged document, but by using a condition field to place the title field *and* its following space, the problem doesn't arise. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Just a simple thought but, > > Have you tried turning on the paragraph format characters, that big > weird P button, while field names are displayed, to make sure there > isn't a rogue space between each merge field? Graham, I know, this was just to make sure there wasn't a rogue space between the conditional field too, after it was changed. MK Graham Mayor Wrote: > You would still get a space attributable to the space following the > missing [quoted text clipped - 4 lines] > the problem doesn't arise. > -- Signaturemasterkeys |
Reply to this Message |
 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.