Help!

How get rid of an extra space doing mail merge when no Mi?

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields RSS
Next:  Outlook 2003 Calendar Navigation Pane  
Author Message
Bill B.
External


Since: Aug 23, 2006
Posts: 6



PostPosted: Fri May 01, 2009 4:26 pm    Post subject: How get rid of an extra space doing mail merge when no Mi?
Archived from groups: microsoft>public>word>mailmerge>fields (more info?)

How do I get rid of an extra space when I do a mail merge and there is no
middle initial?
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Fri May 01, 2009 11:10 pm    Post subject: Re: How get rid of an extra space doing mail merge when no Mi? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
Back to top
Rich/rerat
External


Since: Oct 15, 2006
Posts: 67



PostPosted: Sat May 02, 2009 12:07 pm    Post subject: Re: How get rid of an extra space doing mail merge when no Mi? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Sat May 02, 2009 9:10 pm    Post subject: Re: How get rid of an extra space doing mail merge when no Mi? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
>
>
Back to top
Rich/rerat
External


Since: Oct 15, 2006
Posts: 67



PostPosted: Sun May 03, 2009 11:30 am    Post subject: Re: How get rid of an extra space doing mail merge when no Mi? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum