Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2007

Tip: Looking for answers? Try searching our database.

Mail merge, how can I set dif. case for address block &greeting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RetiredRose - 31 Jan 2007 05:55 GMT
In Microsoft 2003 mail merge, I would like to write the address block in
upper case, ie..MR & MRS SMITH and the greeting with regular letter script
ie..Mr. & Mrs. Smith.  
I will be using window envelopes, so the address block will need to be in
caps.  
I appreciate any help.
Thanks,
Graham Mayor - 31 Jan 2007 07:28 GMT
Don't use the addressblock. Use the individual fields.
Depending on which case the addresses are saved in you can use a formatting
switch to apply the required case
http://www.gmayor.com/formatting_word_fields.htm
Why does the address have to be in upper case for window envelopes? Upper
case is harder to read.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> In Microsoft 2003 mail merge, I would like to write the address block
> in upper case, ie..MR & MRS SMITH and the greeting with regular
[quoted text clipped - 3 lines]
> I appreciate any help.
> Thanks,
RetiredRose - 31 Jan 2007 17:41 GMT
Good question Mr. Mayor, address in caps is a careover from work. In mailing
correspondences, we were instructed to use caps, no punctuation. It is time
to change. Thanks for the info and question.
RetiredRose

> Don't use the addressblock. Use the individual fields.
> Depending on which case the addresses are saved in you can use a formatting
[quoted text clipped - 10 lines]
> > I appreciate any help.
> > Thanks,
Peter Jamieson - 31 Jan 2007 11:52 GMT
If your ADDRESSBLOCK works OK, you should be able to use the character
format switch \*Upper, e.g.

use Alt-F9 to display field codes. Your Addressblock field will look
something roughly like the following (mine's obviously intended for use in
the U.K.):

{ ADDRESSBLOCK \f "<<_TITLE0_ >><<_FIRST0_>><< _LAST0_>><< _SUFFIX0_>>
<<_COMPANY_,
>><<_STREET1_
>><<_STREET2_
>><<_CITY_
>><<_STATE_
>><<_POSTAL_>><<
_COUNTRY_>>" \l 2057 \c 2 \e "United Kingdom" \d }

then type \*Upper before the }, giving you

{ ADDRESSBLOCK \f "<<_TITLE0_ >><<_FIRST0_>><< _LAST0_>><< _SUFFIX0_>>
<<_COMPANY_,
>><<_STREET1_
>><<_STREET2_
>><<_CITY_
>><<_STATE_
>><<_POSTAL_>><<
_COUNTRY_>>" \l 2057 \c 2 \e "United Kingdom" \d \*Upper }

But I have the same question as Graham - do you really need to use
uppercase? If it's a requirement of your postal service, that would be
useful to know.

Peter Jamieson

> In Microsoft 2003 mail merge, I would like to write the address block in
> upper case, ie..MR & MRS SMITH and the greeting with regular letter script
[quoted text clipped - 3 lines]
> I appreciate any help.
> Thanks,
RetiredRose - 31 Jan 2007 17:43 GMT
Thank you Mr. Jamieson, I have it.

> If your ADDRESSBLOCK works OK, you should be able to use the character
> format switch \*Upper, e.g.
[quoted text clipped - 36 lines]
> > I appreciate any help.
> > Thanks,

Rate this thread:






 
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.