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 / March 2007

Tip: Looking for answers? Try searching our database.

How to ignore a feild in Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andrew St-Johnston - 07 Mar 2007 22:38 GMT
I have created an address label for Mail Merge. Becasue I wish the City and
Post Code to be bold I have created an address block by inserting all the
relevant fields. It works perfectly. However becasue a small % of the
mailings are going outside the country the last field is "Country". I do not
want it to print out if the country is "United Kingdom". I can see how to do
this if I use AddressBlock but I  do not know how to get at the fields within
AddressBlock to change their properties. Just to complicate things my default
country for Word is USA. I know I can work around the problem by doing a Find
and Replace once the mereg is completed but I'm idle and want to automate it.

Any help would be much appreciated.
Peter Jamieson - 08 Mar 2007 10:16 GMT
For the ADDRESSBLOCK
a. which version of Word are you using? If it's Word 2003, there should be
an option in the AddressBlock field dialog box for "Only include the
country/region if different than". However, you would also have to ensure
that you have correctly mapped your country field to the relevant field
(probably Country/Region) in Match fields. If it's Word 2002 I cannot
remember if you get that option - certainly, the ADDRESSBLOCK was less
capable.
b. if you can't get ADDRESSBLOCK to work how you want quite quickly, I'd
stick with the individual fields option. (Some would say "don't use the
ADDRESSBLOCK", period.) Although you can change the behaviour of the
"elements" inside the addressblock to an extent, the behaviour of the
ADDRESSBLOCK is not fully documented and so modifications should not be
regarded as supported. The behaviour of the "fields" in the first line in
particular appears to be "hard-coded". Further, any changes you make
manually will probably be lost the next time you modify the addressblock.

The advantage of the ADDRESSBLOCK is, in theory, that it should get the
general layout of the address right for each country. It's much more
difficult to do that using individual fields unless
a. you know what the layout should be or
b. you use fields that already have the text laid out how you want.

However, when it gets to the country you need something like

{ MERGEFIELD "mypreviousfield"
}{ IF "{ MERGEFIELD country \*Upper }" = "UNITED KINGDOM"
"" "
{ MERGEFIELD country }" }

and for that to work all your United Kingdom addresses would have to be laid
exactly as "United Kingdom", case variations OK, additional spaces, UK, U.K.
not OK).

Peter Jamieson
>I have created an address label for Mail Merge. Becasue I wish the City and
> Post Code to be bold I have created an address block by inserting all the
[quoted text clipped - 13 lines]
>
> Any help would be much appreciated.
Andrew St-Johnston - 08 Mar 2007 19:10 GMT
Thank you for the quick response. Ihave been unsuccessful in modifying
AddressBlock so I am going to try plan B. I hope I am right in assuming that
I just substutute your macro for the country field.

> For the ADDRESSBLOCK
>  a. which version of Word are you using? If it's Word 2003, there should be
[quoted text clipped - 48 lines]
> >
> > Any help would be much appreciated.
Peter Jamieson - 08 Mar 2007 19:54 GMT
> I just substutute your macro for the country field.

More or less. All the {} have to be the special field codes you can insert
using ctrl-F9

Peter Jamieson
> Thank you for the quick response. Ihave been unsuccessful in modifying
> AddressBlock so I am going to try plan B. I hope I am right in assuming
[quoted text clipped - 62 lines]
>> >
>> > Any help would be much appreciated.
Andrew St-Johnston - 08 Mar 2007 20:57 GMT
Thanks again

> > I just substutute your macro for the country field.
>
[quoted text clipped - 68 lines]
> >> >
> >> > Any help would be much appreciated.

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.