Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John John is offline
external usenet poster
 
Posts: 307
Default Mergefield statement help


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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MergeField Jeff Bergeron Mailmerge 2 February 22nd 07 03:19 PM
which statement right , question is Choose the correct statement? how many template?when we click new doc Microsoft Word Help 1 October 16th 06 11:15 AM
which statement right , question isChoose the correct statement? how many template?when we click new doc Microsoft Word Help 1 October 15th 06 11:20 PM
How to program if statement in mergefield YaHootie Mailmerge 1 January 17th 05 12:34 PM
Insert carriage return in mergefield statement dixie Mailmerge 2 December 22nd 04 03:42 AM


All times are GMT +1. The time now is 11:48 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"