limiting mailmerge result

[gtiporter]

I have a name and surname fields that merges into word forms

I now have forms asking for first and middle names. At the moment first and
middle names are together in the name field. 2 separate fields would resolve
the problem but with a few hundred documents would be disastrous to do.

im wondering if the name field can be filtered to look for a space and if
there is one (i.e John Andrew has a space because Andrew is the middle name)
it can insert everything up to the space for the first name and everything
after for the middle name.

Any help would be gratefully received

 

[Peter Jamieson]

AFAIK you cannot split the names using field codes, but
a. What is the data source? In some cases you can issue a query via Word
VBA that would split the field in two, just for the documents that need it
b. You could also split the names using the Word Mailmerge events and VBA,
but typically that's a bit more complicate than (a) (in the cases where (a)
is possible)

 

[gtiporter]

The data source is a program called osprey. we enter clients information into
it like name, address etc. I suppose its a database system. This is basic
data that i cant change. I can add additional fields for information i want
to store. The basic and additional fields can then be mailmerged into word
docs

so for a clients name the code is

«Client_Forename»
«Client_Surname»

I can do a field «Client_middle name» and so job done right? It will be a
pig though to change the 200 or so docs to then in name have the forename and
middle name code where previously it was just forename. This might take a few
days and I don't think its that important to warrant it. Just wondered if
there was any other solution.

i thought it might be possible to do something with an if statement i.e if
the result contains a space then insert the result up to it (that i would put
in the forename fcolumn or box) and a separate if statement that inserts
everything after the space (which i would put into the middle names bit)

With this, is your answer the same?