Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
limiting mailmerge result
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
limiting mailmerge result
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: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TOC limiting heading range | Microsoft Word Help | |||
Limiting the bookmark content | Microsoft Word Help | |||
Limiting form fields | Microsoft Word Help | |||
Limiting styles in a template | Microsoft Word Help | |||
Limiting range of TOC | Microsoft Word Help |