Name fields in mailmerge

[oe]

I have a list of names and addresses for mail merge. The data source has
Title, Initial, First_Name and Last_name fields. Sometimes I do not want the
merge to show the Title and Initial, just the First_Name and Last_name, so I
tried putting the first names in the Title field, e.g.:


«Title» «Intial» «Last_name»

Mr & Mrs J Smith
Mrs R Black
Janet & Peter Jones

This is probably not the right way to do it - in any case, I now get a space
between"Janet & Peter" and "Jones".

Can anyone help, please?

TIA

 

[Doug Robbins - Word MVP]

To simplify things what I would do is just have two fields First_Name and
Last_Name and in the First_Name field put

Mr & Mrs J
Mrs R
Janet & Peter

Alternatively, you can use a series of If...then...Else field constructions

{ IF { MERGEFIELD Title } <> "" "{ MERGEFIELD Title }x" "" }y{ IF {
MERGEFIELD Initial } <> "" "{ MERGEFIELD Initial }x" "" }y{ IF { MERGEFIELD
First_Name } <> "" "{ MERGEFIELD First_Name }x" "" }y{ MERGEFIELD
Last_Name }

Where ever I have inserted and "x" in the above, it needs to be replaced by
a space. There should be no space where I have inserted a "y".

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP