View Single Post
 
Old 06-12-2015, 06:22 AM
WillTRiker WillTRiker is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jun 2015
Posts: 3
WillTRiker is on a distinguished road
Default Lay-out problem with mergefield that is not always to be printed

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.

Last edited by WillTRiker; 06-12-2015 at 06:23 AM. Reason: Lay-out got messed up.
Reply With Quote