Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
gtiporter gtiporter is offline
external usenet poster
 
Posts: 2
Default 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   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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
gtiporter gtiporter is offline
external usenet poster
 
Posts: 2
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
TOC limiting heading range GavinS Microsoft Word Help 1 November 14th 08 09:28 AM
Limiting the bookmark content [email protected] Microsoft Word Help 3 June 24th 07 06:16 PM
Limiting form fields KathyHL Microsoft Word Help 6 January 22nd 07 07:06 PM
Limiting styles in a template Tarallen Microsoft Word Help 1 December 29th 06 06:10 PM
Limiting range of TOC Gringotavy Microsoft Word Help 4 January 27th 06 12:07 AM


All times are GMT +1. The time now is 03:25 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"