|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 1st, 2009, 08:26 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How get rid of an extra space doing mail merge when no Mi?
How do I get rid of an extra space when I do a mail merge and there is no
middle initial? 
|
|
#2
May 1st, 2009, 10:57 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How get rid of an extra space doing mail merge when no Mi?
Insert the following mergefields
FirstName MiddleInitial MiddleInitial LastName LastName Then press Alt+F9 to reveal the field codes and you will see: { MERGEFIELD FirstName } { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName }{ MERGEFIELD LastName } Select everying thing except the { MERGEFIELD FirstName } and press Ctrl+F9 to insert a new pair of field delimiters around the selected items as follows: { MERGEFIELD FirstName } { { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName } { MERGEFIELD LastName } } Now, add IF, "", and the other quotation marks as shown below: { MERGEFIELD FirstName } { IF { MERGEFIELD MiddleInitial } "" "{ MERGEFIELD MiddleInitial } { MERGEFIELD LastName }" "{ MERGEFIELD LastName }" } Finally, press Alt+F9 to toggle off the display of the field codes. -- 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, originally posted via msnews.microsoft.com "Bill B." wrote in message ... How do I get rid of an extra space when I do a mail merge and there is no middle initial?
|
|
#3
May 2nd, 2009, 01:07 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How get rid of an extra space doing mail merge when no Mi?
Bill and Doug,
I use "switches" in the mergefields to make things a little Simpler, if there is no {Mergefield Title} field. { MERGEFIELD FirstName}{ MERGEFIELD MiddleInitial \b " "}{ MERGEFIELD LastName \b " "} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Doug Robbins - Word MVP" wrote in message ... Insert the following mergefields FirstName MiddleInitial MiddleInitial LastName LastName Then press Alt+F9 to reveal the field codes and you will see: { MERGEFIELD FirstName } { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName }{ MERGEFIELD LastName } Select everying thing except the { MERGEFIELD FirstName } and press Ctrl+F9 to insert a new pair of field delimiters around the selected items as follows: { MERGEFIELD FirstName } { { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName } { MERGEFIELD LastName } } Now, add IF, "", and the other quotation marks as shown below: { MERGEFIELD FirstName } { IF { MERGEFIELD MiddleInitial } "" "{ MERGEFIELD MiddleInitial } { MERGEFIELD LastName }" "{ MERGEFIELD LastName }" } Finally, press Alt+F9 to toggle off the display of the field codes. -- 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, originally posted via msnews.microsoft.com "Bill B." wrote in message ... How do I get rid of an extra space when I do a mail merge and there is no middle initial?
|
|
#4
May 2nd, 2009, 09:21 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How get rid of an extra space doing mail merge when no Mi?
Live and learn. Thanks.
-- Regards, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Rich/rerat" wrote in message ... Bill and Doug, I use "switches" in the mergefields to make things a little Simpler, if there is no {Mergefield Title} field. { MERGEFIELD FirstName}{ MERGEFIELD MiddleInitial \b " "}{ MERGEFIELD LastName \b " "} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Doug Robbins - Word MVP" wrote in message ... Insert the following mergefields FirstName MiddleInitial MiddleInitial LastName LastName Then press Alt+F9 to reveal the field codes and you will see: { MERGEFIELD FirstName } { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName }{ MERGEFIELD LastName } Select everying thing except the { MERGEFIELD FirstName } and press Ctrl+F9 to insert a new pair of field delimiters around the selected items as follows: { MERGEFIELD FirstName } { { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName } { MERGEFIELD LastName } } Now, add IF, "", and the other quotation marks as shown below: { MERGEFIELD FirstName } { IF { MERGEFIELD MiddleInitial } "" "{ MERGEFIELD MiddleInitial } { MERGEFIELD LastName }" "{ MERGEFIELD LastName }" } Finally, press Alt+F9 to toggle off the display of the field codes. -- 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, originally posted via msnews.microsoft.com "Bill B." wrote in message ... How do I get rid of an extra space when I do a mail merge and there is no middle initial?
|
|
#5
May 3rd, 2009, 12:30 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How get rid of an extra space doing mail merge when no Mi?
Doug,
You are quite welcomed. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Doug Robbins - Word MVP" wrote in message ... Live and learn. Thanks. -- Regards, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Rich/rerat" wrote in message ... Bill and Doug, I use "switches" in the mergefields to make things a little Simpler, if there is no {Mergefield Title} field. { MERGEFIELD FirstName}{ MERGEFIELD MiddleInitial \b " "}{ MERGEFIELD LastName \b " "} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Doug Robbins - Word MVP" wrote in message ... Insert the following mergefields FirstName MiddleInitial MiddleInitial LastName LastName Then press Alt+F9 to reveal the field codes and you will see: { MERGEFIELD FirstName } { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName }{ MERGEFIELD LastName } Select everying thing except the { MERGEFIELD FirstName } and press Ctrl+F9 to insert a new pair of field delimiters around the selected items as follows: { MERGEFIELD FirstName } { { MERGEFIELD MiddleInitial } { MERGEFIELD MiddleInitial } { MERGEFIELD LastName } { MERGEFIELD LastName } } Now, add IF, "", and the other quotation marks as shown below: { MERGEFIELD FirstName } { IF { MERGEFIELD MiddleInitial } "" "{ MERGEFIELD MiddleInitial } { MERGEFIELD LastName }" "{ MERGEFIELD LastName }" } Finally, press Alt+F9 to toggle off the display of the field codes. -- 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, originally posted via msnews.microsoft.com "Bill B." wrote in message ... How do I get rid of an extra space when I do a mail merge and there is no middle initial?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
