Home |
Search |
Today's Posts |
#1
|
|||
|
|||
capitalization of the first letter in a mail merge field + excepti
First of all: a happy New Year to anyone reading this!
Word & Excel (2000) mailmerge My first Q ever in a newsgroup! is: How to get the first letter capatilized in a "multiple words" mergefield, allowing for exceptions? Backround : in Dutch you have sort of difficult surname protocols when writing official letters, subject to the rather complicated "format" of the surname, cause the actual surname often consist of multiple names : eg. full name is: Mr. Jan (first name) van Dal (surname consists of 2 names; van = "precursing" surname and "Wal'= "actual" surname) - then the adres by letter would be eg. Dear Mr. Van Dal (notice the capitalization! of van to Van); similarly de Wal - De Wal, van der Wal- Van der Wal, het Paard- Het Paard, uit de Grond- Uit de Grond, op der Heide- Op der Heide, etc, etc, ; however!: 't Hoofd ('t = short for het) remains unchanged as well as d'Hond (d'= short for de). Still following me?, Ok. I have an Excel database of these surnames consisting of 2 labels: one harbours the precursing surname in undercapitals (van.., de...,van der, op der, 't, d', etc ,and the other of the second part (Wal, Paard, Grond, Heide, Hoofd, Hond, etc. [remain unchanged] The big Q is, how, if at all, do I "instruct" the mergefield to get what I want? that is capitalize the first letter only! of the precursing surname, but do not capitalize if an apostrophe (') before or after the first letter is occuring? Do appreciate any hints to solve this challenge! Many thanks in adavance! -- no need for my signature |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
How do I get a field to self adjust in a mail merge? | Mailmerge | |||
How can I edit the format of a mail merge field after it has been. | Mailmerge | |||
Can you use mail merge when the address field is inside a text box | Mailmerge |