 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2007Can case be pre-determined so that merged document has correct upper and title cases?
I was wondering, as I've never had this come up before, if we can pre-set what the case of the finished, merged document? For example, my intention later on today at work is to create the source, data file in Excel with first and last name fields. Hopefully the person can just enter both in title case. But in the Word label document, will need one of 4 labels to be like this: LAST NAME, First Name while the other 3 will have their format as First Name Last Name. Can this be done? Thanks! :oD >I was wondering, as I've never had this come up before, if we can > pre-set what the case of the finished, merged document? For example, [quoted text clipped - 12 lines] > > Can this be done? Thanks! :oD Hi, everyone! I'm at the office now so hoping someone knows the answer to this one. I don't know how to do this, if it can even be done. I'm hoping for some code we can put before/after the field code in the pertinent labels when we need the one label to show last name in upper case. Thanks so much. :oD Simple enough using switches eg {Mergefield LastName \*Upper} will give you LASTNAME see http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I was wondering, as I've never had this come up before, if we can > pre-set what the case of the finished, merged document? For example, [quoted text clipped - 12 lines] > > Can this be done? Thanks! :oD > Simple enough using switches > eg {Mergefield LastName \*Upper} will give you LASTNAME > see http://www.gmayor.com/formatting_word_fields.htm Thank you, thank you! I never knew about these switches. Great. Will try it out today when I make the merge files. Cheers. :oD > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP [quoted text clipped - 19 lines] >> >> Can this be done? Thanks! :oD >> Simple enough using switches >> eg {Mergefield LastName \*Upper} will give you LASTNAME >> see http://www.gmayor.com/formatting_word_fields.htm Thanks for this link here. When I did the changes the first time, it didn't work. I needed to follow the instructions given on this page. Worked beautifully! >Thank you, thank you! I never knew about these switches. Great. Will try >it out today when I make the merge files. [quoted text clipped - 24 lines] >>> >>> Can this be done? Thanks! :oD You are welcome :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >>> Simple enough using switches >>> eg {Mergefield LastName \*Upper} will give you LASTNAME [quoted text clipped - 32 lines] >>>> >>>> Can this be done? Thanks! :oD |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.