View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default limiting mailmerge result

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)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"gtiporter" wrote in message
...
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