Ugh ... just started my first tentative steps with this and running head first into my first problem.



I'm in the Netherlands and one of the fields in our database for our Employees holds the Country of the home address. As we're close to Germany we have some employees that live in Germany working with us.

What managment wants is that when a letter is send to someone in the Netherlands the country is NOT mentioned in the letter, but if someone lives in Germany the country should be listed. I succeeded in doing this and the last 2 lines atm read like this:

{ IF { MERGEFIELD "COUNTRY"}<>"NETHERLANDS" { MERGEFIELD "COUNTRY"}}
Dear {MERGEFIELD "FULLNAME"},

My problem is the text that follows right after the line with the country code. There is supposed to be one blank line following the address.
When I get a resident from the Netherland that is exactly what I get, but with someone from Germany the name employee is directly under the country.
How do I fix this?
I tried the other way around also. In other words making the Country list as blank for a Dutch resident, but then it works for a German address, but for a Dutch address I get 2 blank lines. Arrrrgghh.
Any help much appreciated.

You could encode the field as:
{IF{MERGEFIELD COUNTRY}<> "NETHERLANDS" "{MERGEFIELD COUNTRY}¶
"}
where the ¶ is a real paragraph break. Note the double quotes before the mergefield and after the paragraph break.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you very much Paul. That worked like a charm.