Word Mail Merge / Forms - inserting "and" before the last item in alist in a sentence.

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

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

How will you know whether or not to include/exclude a name in any given
sentence?


Peter Jamieson

http://tips.pjmsn.me.uk

On 28/01/2010 20:36, Larry Cortez wrote:
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