Hi How do you delete the extra space in a name if they
have no middle initial in a mail merge? Some of my
records have a middle initial and some don't. Thanks for
the help. SandyG
Doug Robbins - Word MVP - 30 Sep 2003 06:03 GMT
Hi Sandy,
Use and IF THEN ELSE field that checks if the middle initial is blank. If
it is, have it insert the LastName, if it is not, have it insert the Middle
Initial, plus a space, plust the Last Name.
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
> Hi How do you delete the extra space in a name if they
> have no middle initial in a mail merge? Some of my
> records have a middle initial and some don't. Thanks for
> the help. SandyG
Peter Jamieson - 30 Sep 2003 08:27 GMT
If your data source records have separate "first name", "middle initial" and
"last name" type fields, you can go with Doug's solution - if you are using
an ADDRESSBLOCK or GREETINGLINE type fields you will have to change to use
the individual field names.
If the problem is that you have a data source where the name is all in one
field, you will have to pre-process the data in some way because Word IF
fields won't help you. Precisely how you might do that would depend on what
the data source is.
--
Peter Jamieson
MS Word MVP
> Hi How do you delete the extra space in a name if they
> have no middle initial in a mail merge? Some of my
> records have a middle initial and some don't. Thanks for
> the help. SandyG