Compare Mailing_Address with Business_Address that includes co
One thing to look out for is a 128-ish character limit on comparisons - that
would be a lot for addresses but it depends on how much is in the address.
Peter Jamieson
"macropod" wrote in message
...
Hi Heliotrope,
The fact you got a case where with no business address at all the company
name showed up suggests there may be something wrong with your data
source.
There's no reason I can see why the code would work as advertised. The
presence of Unicode characters shouldn't change that, though I admit I
don't
quite know how Word treats them if they appear in the data preceding the
country.
Cheers
--
macropod
[MVP - Microsoft Word]
"Heliotrope" wrote in message
...
Thank you very much. Unfortunately, I could not get this suggestion to
work,
though I tried several permutations in addition. I get inconsistent
results -
even one where with no business address at all the compnay name showed
up.
(I
know that's odd) Could this have to do with the character set? I noticed
the
Word file conversion dialogue shows Unicode.
Thanks!
"macropod" wrote:
Hi Heliotrope,
Actually, you don't need to *remove* the country from Business_Address
before making the comparison. All you need to do is to code the field
to
disregard it.
An IF test with a wildcard will do the trick. The field construction
is:
{IF{MERGEFIELD Business_Address}= "{ MERGEFIELD Mailing_Address }*"
{MERGEFIELD "Company"}}
Cheers
--
macropod
[MVP - Microsoft Word]
"Heliotrope" wrote in message
...
This question derives from the helpful exchange "Conditionally print
outlook
company in mail merge (4/22/06)."
I tried the suggested solution but found that when Business_Address
includes
the country, the routine fails. Here's the key part:
{IF "{ MERGEFIELD "Mailing_Address" }" = "{ MERGEFIELD
"Business_Address" }"
"{MERGEFIELD "Company"}. How do I programatically remove the
country
from
Business_Address before making the comparison?
|