How to retain a format change during a merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sagit - 23 Aug 2005 05:25 GMT

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.

Signature

S Jan

Reply to this Message

Graham Mayor - 23 Aug 2005 08:22 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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,
[quoted text clipped - 6 lines]
> without re-entering?
> Any help at all will be greatly appreciated.

Reply to this Message

Sagit - 23 Aug 2005 12:21 GMT

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.

Signature

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
[quoted text clipped - 15 lines]
> > without re-entering?
> > Any help at all will be greatly appreciated.

Reply to this Message

TedMi - 23 Aug 2005 14:58 GMT

> .... 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

Reply to this Message

Rate this thread: