Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting - UPPERCASE to Title Case
Hi, I am using excel as the database for a mail merge document. But all the
data is in uppercase format, is there any way I can change this format to Title Case without having to go throuth each letter merged? |
#2
|
|||
|
|||
Use the Excel data source as the basis of a catalog (or in Word XP and
later, a directory) type mailmerge in the main document of which you insert the mergefields into the cells of a one row table. After you execute the merge, select the necessary columns and use the Change Case item on the Formatting toolbar in Word to select Title Case. Then add a row at the top of the file into which you insert mergefield names for each column, save the document and then use it as the data source for the formletter mailmerge. -- 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 "Mali" wrote in message ... Hi, I am using excel as the database for a mail merge document. But all the data is in uppercase format, is there any way I can change this format to Title Case without having to go throuth each letter merged? |
#3
|
|||
|
|||
Thank you. This is something new for me.
"Doug Robbins" wrote: Use the Excel data source as the basis of a catalog (or in Word XP and later, a directory) type mailmerge in the main document of which you insert the mergefields into the cells of a one row table. After you execute the merge, select the necessary columns and use the Change Case item on the Formatting toolbar in Word to select Title Case. Then add a row at the top of the file into which you insert mergefield names for each column, save the document and then use it as the data source for the formletter mailmerge. -- 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 "Mali" wrote in message ... Hi, I am using excel as the database for a mail merge document. But all the data is in uppercase format, is there any way I can change this format to Title Case without having to go throuth each letter merged? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method for displaying dollar amount as written on bank check | Microsoft Word Help | |||
Change Case (Title Case) | Mailmerge | |||
Title case in Word should automatically not capitalize short word. | Microsoft Word Help | |||
How do I turn dollar amounts into words? | New Users | |||
Apply Style but keep direct formatting? | New Users |