Thread
:
Another Mail Merge Problem - Word 2003
View Single Post
#
7
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
Posts: 19,312
Another Mail Merge Problem - Word 2003
It is quite simple:
Town
If the county has content move down a line and enter the county and the
postcode (it doesn't matter of the postcode is empty here as the blank space
is at the end of the line).
If the county has no content have a look in postcode.
If postcode has content move down a line and enter the postcode
If both county and postcode are empty stay on the line with town
then move down a line and add the country.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
wrote:
Thanks Graham,
It seems very complicated but it works - I won't pretend to understand
how!
Best Regards
John
On 16 Mar, 13:33, wrote:
Peter,
Thanks for the advice. The code at present is as follows:
{ IF { MERGEFIELD Country } = "" { MERGEFIELD PostCode }
"{ MERGEFIELD
Country } { MERGEFIELD PostCode }" }
I understand what you are saying but, if, as you suggest, I put
{Mergefield Postcode} at the end, it will be OK if Potscode is blank
but if it is not, I will get Postcode twice.
I'm not sure how this solves the problem.
Best Regards
John
On 16 Mar, 13:15, "Peter Jamieson"
wrote:
How about
{ IF "{ MERGEFIELD County }" = "" "" "{ MERGEFIELD County } " }{
MERGEFIELD Postcode }
The thing about blank line suppression is that it isn't any old
blank line that's suppressed - it's blank lines formed from
MERGEFIELD fields, but MERGEFIELD fields nested inside some other
construct such as an IF field don't count. So only by inserting a
MERGEFIELD that you know to be blank can you suppress the line.
More or less.
Peter Jamieson
wrote in message
oups.com...
I have two Mergefields on the same line County and
PostCode. In some cases, like sending a letter to Australia,
the County field is blank but the PostCode field contains data.
In an earlier post Doug Robbins showed me how to use If-Then-Else
coding to print, one or other or both fields but I've hit another
problem.
Normally, if a field is blank, the line does not print and the
remainder of the address closes up. However, in the line which
contains the code, if the both "County" and "Post Code" are blank,
the line remains, so I get a blank line between "Town" and
"Country". I've tried using a second "If" statement but it makes
no difference. Could someone please advise how I can get rid of
the blank line.
Best Regards
John- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
Reply With Quote
Graham Mayor
View Public Profile
Find all posts by Graham Mayor