Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2003

Tip: Looking for answers? Try searching our database.

Mail merge middle Initial

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SandyG - 30 Sep 2003 04:14 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.