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?
"Peter Jamieson" wrote:
[Quoted Text] > 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" <gtiporter[ at ]discussions.microsoft.com> wrote in message > news:6356CB88-0620-4E88-A826-60052F190631[ at ]microsoft.com... > >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 > > > > > > |