I have an Excel file of names and addresses in all uppercase.
They need to be in upper and lower case. When I do a mail merge,
I do a Format, Change Case, Title Case on the inserted heading names on the
document that is created just before the merge. I thought that the
formatting would be retained after the merge, but it is not - everything goes
back to upper case after the merge is completed. Is there any way that I
can a) retain the formatting after the merge or b) change the Excel
file to upper and lower case easily without re-entering?
Any help at all will be greatly appreciated.

--
S Jan

The best you will be able to manage is to use formatting switches to achieve
what you want. http://www.gmayor.com/formatting_word_fields.htm
eg { Mergefield FieldName \*Lower \*FirstCap}
Unfortunately this is not true sentence case. Only the first letter is
capitalised. The lower case switch is needed to first convert to lower case.
For more complex field contents, you will have to run a wildcard replace to
capitalise sentences that are not already capitalised -
http://www.gmayor.com/replace_using_wildcards.htm

--

Graham Mayor - Word MVP

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


--

Graham Mayor - Word MVP

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


Sagit wrote:
I have an Excel file of names and addresses in all uppercase.
They need to be in upper and lower case. When I do a mail merge,
I do a Format, Change Case, Title Case on the inserted heading names
on the document that is created just before the merge. I thought
that the formatting would be retained after the merge, but it is not
- everything goes back to upper case after the merge is completed.
Is there any way that I can a) retain the formatting after the
merge or b) change the Excel file to upper and lower case easily
without re-entering?
Any help at all will be greatly appreciated.

Thank you so much. I found your web site very helpful concerning switches.
This is new to me, so you have shown me a whole new world in Word! Thank
you, thank you.
--
S Jan


"Graham Mayor" wrote:

The best you will be able to manage is to use formatting switches to achieve
what you want. http://www.gmayor.com/formatting_word_fields.htm
eg { Mergefield FieldName \*Lower \*FirstCap}
Unfortunately this is not true sentence case. Only the first letter is
capitalised. The lower case switch is needed to first convert to lower case.
For more complex field contents, you will have to run a wildcard replace to
capitalise sentences that are not already capitalised -
http://www.gmayor.com/replace_using_wildcards.htm

--

Graham Mayor - Word MVP

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


--

Graham Mayor - Word MVP

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


Sagit wrote:
I have an Excel file of names and addresses in all uppercase.
They need to be in upper and lower case. When I do a mail merge,
I do a Format, Change Case, Title Case on the inserted heading names
on the document that is created just before the merge. I thought
that the formatting would be retained after the merge, but it is not
- everything goes back to upper case after the merge is completed.
Is there any way that I can a) retain the formatting after the
merge or b) change the Excel file to upper and lower case easily
without re-entering?
Any help at all will be greatly appreciated.

"Sagit" wrote:

.... b) change the Excel
file to upper and lower case easily without re-entering?

Select the entire Excel worksheet.
Copy and Paste it into a blank Word document. That will create a table.
Select the entire table and Format Change Case Title Case
Copy and paste the entire table into a blank Excel Worksheet.
-----------
-Ted