View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Word Mail Merge / Forms - inserting "and" before the last item in a list in a sentence.

Hi Larry,

You could use a nested 'IF' field construction like:
«NameField1»{IF«NameField6» "" ", «NameField2», «NameField3», «NameField4», «NameField5» and «NameField6»" {IF«NameField5» "" ",
«NameField2», «NameField3», «NameField4» and «NameField5»" {IF«NameField4» "" ", «NameField2», «NameField3» and «NameField4»"
{IF«NameField3» "" ", «NameField2» and «NameField3»" {IF«NameField2» "" " and «NameField2»" ""}}}}}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields,
which you can insert from the mailmerge toolbar.


--
Cheers
macropod
[Microsoft MVP - Word]


"Larry Cortez" wrote in message ...
I have created a Microsoft Word form in which users will imput names into NameField1, NameField2, ... NameField6. The input will
be used to populate the non-form part of the document in sentences. The some sentences will use all of the names, some will use
only some or one name. For instance a sentence may end,

.... Name1, Name2, Name3, Name4, Name5, and Name6.

Another may end,

.... Name1, Name3, Name4, and Name5.

My problem is that I cannot figure out how to programatically cause the "and" to fall before the last NameX in the list.

Any thoughts on how to accomplish this will be appreciated!

Larry


Submitted via EggHeadCafe - Software Developer Portal of Choice
New Idea to Convert DataReader to DataTable
http://www.eggheadcafe.com/tutorials...ert-datar.aspx