TechTalkz.com Logo Ask the Experts!

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft Office > Microsoft Office Word

Mail Merge Change Case Format

Microsoft Office Word

 
 
 
Thread Tools Display Modes
Old 14-02-2008, 09:09 AM   #1
Clara
Guest
 
Posts: n/a
Mail Merge Change Case Format

Hi,

I've completed my mail merge. However, the data source is in CAPS, and I'd
like to change that to Title Case.

For example:
JOHN DOE vs. John Doe

How can I do this without have to go in each page and formatting??
 
Old 14-02-2008, 09:10 AM   #2
Suzanne S. Barnhill
Guest
 
Posts: n/a
Re: Mail Merge Change Case Format

You can add a \* Caps switch to the merge field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Clara" <Clara@discussions.microsoft.com> wrote in message
news:7F0A427D-C3A3-42C9-98EC-E8DC23A8DE47@microsoft.com...
> Hi,
>
> I've completed my mail merge. However, the data source is in CAPS, and
> I'd
> like to change that to Title Case.
>
> For example:
> JOHN DOE vs. John Doe
>
> How can I do this without have to go in each page and formatting??
>



 
Old 14-02-2008, 09:10 AM   #3
Suzanne S. Barnhill
Guest
 
Posts: n/a
Re: Mail Merge Change Case Format

You can add a \* Caps switch to the merge field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Clara" <Clara@discussions.microsoft.com> wrote in message
news:7F0A427D-C3A3-42C9-98EC-E8DC23A8DE47@microsoft.com...
> Hi,
>
> I've completed my mail merge. However, the data source is in CAPS, and
> I'd
> like to change that to Title Case.
>
> For example:
> JOHN DOE vs. John Doe
>
> How can I do this without have to go in each page and formatting??
>



 
Old 14-02-2008, 09:13 AM   #4
Graham Mayor
Guest
 
Posts: n/a
Re: Mail Merge Change Case Format

While the *\Caps switch should work, you may find circumstances where it
doesn't. If that happens use a \*Lower switch before the *\Caps switch,

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Suzanne S. Barnhill wrote:
> You can add a \* Caps switch to the merge field.
>
>
> "Clara" <Clara@discussions.microsoft.com> wrote in message
> news:7F0A427D-C3A3-42C9-98EC-E8DC23A8DE47@microsoft.com...
>> Hi,
>>
>> I've completed my mail merge. However, the data source is in CAPS,
>> and I'd
>> like to change that to Title Case.
>>
>> For example:
>> JOHN DOE vs. John Doe
>>
>> How can I do this without have to go in each page and formatting??



 
Old 14-02-2008, 09:13 AM   #5
Graham Mayor
Guest
 
Posts: n/a
Re: Mail Merge Change Case Format

While the *\Caps switch should work, you may find circumstances where it
doesn't. If that happens use a \*Lower switch before the *\Caps switch,

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Suzanne S. Barnhill wrote:
> You can add a \* Caps switch to the merge field.
>
>
> "Clara" <Clara@discussions.microsoft.com> wrote in message
> news:7F0A427D-C3A3-42C9-98EC-E8DC23A8DE47@microsoft.com...
>> Hi,
>>
>> I've completed my mail merge. However, the data source is in CAPS,
>> and I'd
>> like to change that to Title Case.
>>
>> For example:
>> JOHN DOE vs. John Doe
>>
>> How can I do this without have to go in each page and formatting??



 
Old 14-02-2008, 09:17 AM   #6
Graham Mayor
Guest
 
Posts: n/a
Re: Mail Merge Change Case Format

While the *\Caps switch should work, you may find circumstances where it
doesn't. If that happens use a \*Lower switch before the *\Caps switch,

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Suzanne S. Barnhill wrote:
> You can add a \* Caps switch to the merge field.
>
>
> "Clara" <Clara@discussions.microsoft.com> wrote in message
> news:7F0A427D-C3A3-42C9-98EC-E8DC23A8DE47@microsoft.com...
>> Hi,
>>
>> I've completed my mail merge. However, the data source is in CAPS,
>> and I'd
>> like to change that to Title Case.
>>
>> For example:
>> JOHN DOE vs. John Doe
>>
>> How can I do this without have to go in each page and formatting??



 
 

Thread Tools
Display Modes



< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT. The time now is 06:46 AM.


vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2013, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional