If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Method for displaying dollar amount as written on bank check | samandmonty | General Discussion | 5 | May 11th, 2005 10:54 PM |
convert value in word. For Exampe Rs.115.00 convert into word as . | Shakti | General Discussion | 1 | May 10th, 2005 12:00 PM |
Formatting fields to Title Case | DianeD | Setting Up & Running Reports | 1 | April 29th, 2005 04:49 AM |
Uppercase to Title Case | Jeannette | General Discussion | 1 | November 18th, 2004 09:07 PM |
Readding Numerical value to ext | Hoang Han | Worksheet Functions | 2 | December 4th, 2003 05:37 PM |