 |
 | 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 / May 2006If then else question
Can somebody help me with the correct syntax for the following: If NAME2 is blank Then NAME1description + ",and" Else NAME1description { IF { MERGEFIELD NAME2 } = "" "{ MERGEFIELD NAME1description }, and " "{ MERGEFIELD NAME1descript }" } You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9 to toggle their display.  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 somebody help me with the correct syntax for the following: > > If NAME2 is blank > Then NAME1description + ",and" > Else NAME1descript Thanks for your prompt reply, but unfortunately, I now understand this is not the result I want, after all. I have 5 mergefields for names ("John Smith", etc) and 5 merge fields for descriptions ("an individual") but don't know in advance how many the record will actually contain. This is what I got using your suggestions: JOHN SMITH, an individual MARY SMITH, an individual an individual, and an individual, and an individual, and an individual, and Here's the result I really need: JOHN SMITH, an individual MARY SMITH, an individual, and So, I always need ", and" after the last name. Is there a way to do this? Sorry about my confused mind! > { IF { MERGEFIELD NAME2 } = "" "{ MERGEFIELD NAME1description }, and " "{ > MERGEFIELD NAME1descript }" } [quoted text clipped - 6 lines] > > Then NAME1description + ",and" > > Else NAME1descript If you always need ", and" after the last name, do not make it part of the mergefield construction. Simply have it as text in the document. 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 > Thanks for your prompt reply, but unfortunately, I now understand this is > not [quoted text clipped - 31 lines] >> > Then NAME1description + ",and" >> > Else NAME1descript That was the first thing I tried - the result was spaces before the comma like this: JOHN SMITH, an individual; MARY SMITH, an individual ,and > If you always need ", and" after the last name, do not make it part of the > mergefield construction. Simply have it as text in the document. You must have some uneeded spaces in the field construction some where. 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 > That was the first thing I tried - the result was spaces before the comma > like this: [quoted text clipped - 4 lines] >> the >> mergefield construction. Simply have it as text in the document. No, unfortunately, they are not uneeded: Here's what I have as merge codes (and I will add ", and" per your suggestion): Name1, Name1description Name2, Name2 description Name3 Name3, description Name4, Name4 description Name 5, Name 5 description, and This works fine if indeed 5 names are merged. But if any less than 5 are merged, there are spaces before ", and". So if there is only one name in the record, the result is: JOHN SMITH, an individual , and That's why the ", and" needs to be in the mergecode. Hope this is clear and that you have a solution. > You must have some uneeded spaces in the field construction some where. You still need the If...then...Else... fields to check for data in Name2, Name3, Name4 and Name5. If there is not data insert nothing, if there is data, insert that data preceeded by whatever it is that you want to separate it from the previous item. The construction will be { MERGEFIELD Name1 }, { MERGEFIELD Name1Description }{ IF { MERGEFIELD Name2 } = "" "" "; { MERGEFIELD Name2 }, { MERGEFIELD Name2Description }" }{IF { MERGEFIELD Name3 } = "" "" "; { MERGEFIELD Name3 }, { MERGEFIELD Name3Description }" }{IF { MERGEFIELD Name4 } = "" "" "; { MERGEFIELD Name4 }, { MERGEFIELD Name4Description }" }(IF { MERGEFIELD Name5 } = "" "" "; { MERGEFIELD Name5 }, { MERGEFIELD Name5Description }" }, and Note that there is no space between the } and the { IF 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 > No, unfortunately, they are not uneeded: > [quoted text clipped - 15 lines] > >> You must have some uneeded spaces in the field construction some where. Thanks SO much - that was great. There is only one teeny thing left - somehow I am getting 2 spaces between each record, and I'd really like only one. I tried playing around with the quotes, but obviously don't understand how to do it. Can you show me please? > You still need the If...then...Else... fields to check for data in Name2, > Name3, Name4 and Name5. If there is not data insert nothing, if there is [quoted text clipped - 12 lines] > > Note that there is no space between the } and the { IF Is that two spaces between the semicolon and the first letter of the following name? Or, do you mean each record in the data source? 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 > Thanks SO much - that was great. There is only one teeny thing left - > somehow I am getting 2 spaces between each record, and I'd really like [quoted text clipped - 23 lines] >> >> Note that there is no space between the } and the { IF It's between the semicolon and the first letter of the following name > Is that two spaces between the semicolon and the first letter of the > following name? Or, do you mean each record in the data source? Maybe there is a space before the name in the data source. But you can always remove the space after the semi-colon in the field construction: { MERGEFIELD Name1 }, { MERGEFIELD Name1Description }{ IF { MERGEFIELD Name2 } = "" "" ";{ MERGEFIELD Name2 }, { MERGEFIELD Name2Description }" }{IF { MERGEFIELD Name3 } = "" "" ";{ MERGEFIELD Name3 }, { MERGEFIELD Name3Description }" }{IF { MERGEFIELD Name4 } = "" "" ";{ MERGEFIELD Name4 }, { MERGEFIELD Name4Description }" }(IF { MERGEFIELD Name5 } = "" "" ";{ MERGEFIELD Name5 }, { MERGEFIELD Name5Description }" }, and 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 > It's between the semicolon and the first letter of the following name > >> Is that two spaces between the semicolon and the first letter of the >> following name? Or, do you mean each record in the data source? Sorry, I didn't use the semi-colon because it is built into the description. I keep playing with those quotes but either I get two spaces or none. Still hoping you have a solution. Thanks. > Maybe there is a space before the name in the data source. But you can > always remove the space after the semi-colon in the field construction: [quoted text clipped - 6 lines] > Name5 } = "" "" ";{ MERGEFIELD Name5 }, { MERGEFIELD Name5Description }" }, > and Ok, now I figured it out and removed the space where the semi-colon WOULD have been had I used it! I was off on the wrong track with the quotes. That wraps it up. Thank you again very much for your patience and knowledge. |
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.