Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]() Result I want whether employee has an entry in "aka" field or not. «EmployeeFirst» L. «EmployeeLast» aka Larry Alan Young v. «Employer» {MERGEFIELD EmployeeFirst} {IF {MERGEFIELD EE_MI} "" "{MERGEFIELD EE_MI } "}{MERGEFIELD EmployeeLast} {IF {MERGEFIELD AKA} "" "{MERGEFIELD AKA}"}v. {MERGEFIELD Employer} Merged Result using above: Name with aka in field: Alan L. Young aka Larry Alan Youngv. (this result needs space between g and v.) Name with blank aka field: Martin Begg v. (this result has correct spacing) If I instead add a space in front of the v. in above mergefield statement, I get the following result: Name with aka in field: Alan L. Young aka Larry Alan Young v. (this spacing is correct between g and v.) Name with blank aka field: Martin Begg v. (this result has added an additional space and is incorrect) Same Mergefield statement but in sentence format: The employee «EmployeeFirst» «EmployeeLast». The next sentence starts. The employee {MERGEFIELD EmployeeFirst} {IF {MERGEFIELD EE_MI} "" "{MERGEFIELD EE_MI } "}{MERGEFIELD EmployeeLast} {IF {MERGEFIELD AKA} "" "{MERGEFIELD AKA}"}. The next sentance starts Merge Result: Name with aka in field: Alan L. Youngaka Larry Alan Young. (needs space between g and aka, but the spacing at end with period is correct) Name with blank aka field: Martin Begg. (has correct spacing at period) Can someone tell me where my mergefield statement is incorrect so that I can use in all instances shown above. Thank you, AJ -- John R. |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MergeField | Mailmerge | |||
which statement right , question is Choose the correct statement? | Microsoft Word Help | |||
which statement right , question isChoose the correct statement? | Microsoft Word Help | |||
How to program if statement in mergefield | Mailmerge | |||
Insert carriage return in mergefield statement | Mailmerge |