Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Peter is offline
external usenet poster
 
Posts: 111
Default mail merge - conditions and line breaks

Im newly working at the NZ affiliate of an international charitable
organisation. The database currently used is fairly old and some fields were
never perfectly consistent with our local situation. So over the years data
entry has been inconsistent. Medium term goal is a new international
database and cleansed data, but in the meantime I would appreciate coding
ideas for a specific scenario.

For addresses in all correspondence the field layout should include:

Suburb (if not null)
City Postcode

Where Suburb and City both have values, the data entry is consistent.
But where Suburb is blank (eg for a small rural town) the City value may
have been typed into the Suburb or City field. In such a case the
alternate field will then be null.

So I need a set of conditional field merges that cover (I think) three
possibilities:

Suburb
City Postcode

or
City Postcode (if Suburb is Null)

or
Suburb Postcode (if City is Null)

I can do bits of this but am having trouble with the layout needing to be on
one or two lines. I presume I need to insert a line break or equivalent but
dont know how to code this.

Thanks in advance for any help.

Peter.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge - conditions and line breaks

Use the following field construction

{ IF { MERGEFIELD Suburb } "" "{ IF { MERGEFIELD City } "" "{
MERGEFIELD Suburb }¶
{ MERGEFIELD City } { MERGEFIELD PostCode }" "{ MERGEFIELD Suburb } {
MERGEFIELD PostCode }" } "{ MERGEFIELD City } {MERGEFIELD PostCode }" }

Where the ¶ appears in the above, press Enter (or Shift+Enter)

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off their display.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Peter" wrote in message
...
Im newly working at the NZ affiliate of an international charitable
organisation. The database currently used is fairly old and some fields
were
never perfectly consistent with our local situation. So over the years
data
entry has been inconsistent. Medium term goal is a new international
database and cleansed data, but in the meantime I would appreciate coding
ideas for a specific scenario.

For addresses in all correspondence the field layout should include:

Suburb (if not null)
City Postcode

Where Suburb and City both have values, the data entry is consistent.
But where Suburb is blank (eg for a small rural town) the City value
may
have been typed into the Suburb or City field. In such a case the
alternate field will then be null.

So I need a set of conditional field merges that cover (I think) three
possibilities:

Suburb
City Postcode

or
City Postcode (if Suburb is Null)

or
Suburb Postcode (if City is Null)

I can do bits of this but am having trouble with the layout needing to be
on
one or two lines. I presume I need to insert a line break or equivalent
but
dont know how to code this.

Thanks in advance for any help.

Peter.


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Peter is offline
external usenet poster
 
Posts: 111
Default mail merge - conditions and line breaks

Thanks for your help. This has been just what I needed to sort things out.

Peter

(PS - In case someone else has a similar issue and wants to draw on this
pattern, I think there's a quotation mark needed - I've added a quote
immediately after the 4th right hand field delimiter from the end. Without
it I lost some of my postcodes.)

"Doug Robbins - Word MVP" wrote:

Use the following field construction

{ IF { MERGEFIELD Suburb } "" "{ IF { MERGEFIELD City } "" "{
MERGEFIELD Suburb }¶
{ MERGEFIELD City } { MERGEFIELD PostCode }" "{ MERGEFIELD Suburb } {
MERGEFIELD PostCode }" } "{ MERGEFIELD City } {MERGEFIELD PostCode }" }

Where the ¶ appears in the above, press Enter (or Shift+Enter)

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off their display.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Peter" wrote in message
...
Im newly working at the NZ affiliate of an international charitable
organisation. The database currently used is fairly old and some fields
were
never perfectly consistent with our local situation. So over the years
data
entry has been inconsistent. Medium term goal is a new international
database and cleansed data, but in the meantime I would appreciate coding
ideas for a specific scenario.

For addresses in all correspondence the field layout should include:

Suburb (if not null)
City Postcode

Where Suburb and City both have values, the data entry is consistent.
But where Suburb is blank (eg for a small rural town) the City value
may
have been typed into the Suburb or City field. In such a case the
alternate field will then be null.

So I need a set of conditional field merges that cover (I think) three
possibilities:

Suburb
City Postcode

or
City Postcode (if Suburb is Null)

or
Suburb Postcode (if City is Null)

I can do bits of this but am having trouble with the layout needing to be
on
one or two lines. I presume I need to insert a line break or equivalent
but
dont know how to code this.

Thanks in advance for any help.

Peter.


Reply
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
mail merge w/ excel and conditions Ahmayzin1 Mailmerge 2 January 3rd 09 05:58 AM
email merge creating line breaks MB Mailmerge 1 September 13th 08 11:17 PM
Mail Merge Directory - page breaks Bob623 Mailmerge 1 June 30th 08 08:51 PM
Multiple conditions in merge Stephen Green Mailmerge 12 December 20th 05 06:38 PM
replace auto line breaks with manual line breaks DavidH Microsoft Word Help 4 October 29th 05 11:57 PM


All times are GMT +1. The time now is 06:08 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"