Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
S_G_P S_G_P is offline
Junior Member
 
Posts: 1
Default Address Formatting Mail Merge

Hi,

Im trying to produce a mail merge that is linked to a list of Addresses - 7 fields in total all of which are in CAPITALS and can included a number or be blank. In Excel terms Im trying to replicate something like the PROPER function.

I would like the address formatted so that the start of each word is capitalised. At the moment Im using the format switch {MERGEFEILD Address_Line_1 \*Lower\*FirstCap} which is resolving some of the issues but needs to a be little more sophisticated.

For Example if I had the below address:

Address Line 1 (House Name)=
Address Line 2 = 118 NEW ROAD
Address Line 3 = STAFFORD
Address Line 4 =
Address Line 5 = BIRMINGHAM
Country = UK
Postcode = WS11 4PD

I would want it to be formatted like this:

118 New Road
Stafford
Birmingham
UK
WS11 4PD

The problems Im having is getting the mail merge to ignore any address lines that are blank, ignoring the numbers in Address Line 2 so that is capitalises New and lastly coming with something so that it would also apply a capital to the second word Road in Address Line 2. Different addresses will populate different Address lines so would need something that could adapt to these variables.

Im no expert with Word but would appreciate any help or guidance you may be able to provide.

Many thanks
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
add a new address to mail merge address list in Word 2007 Jayar Mailmerge 1 June 24th 08 06:20 AM
Eliminate formatting of e-mail address Michael Microsoft Word Help 3 June 28th 06 05:48 AM
Mail Merge Address Block Missing Address 3 Joe Champagne Mailmerge 3 September 23rd 05 06:09 PM
mail merge address formatting katet Mailmerge 4 August 10th 05 05:03 PM
How do I select an outgoing e-mail address for Mail Merge? Tigerlily264 Mailmerge 1 March 31st 05 08:07 AM


All times are GMT +1. The time now is 10:31 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"