Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-12-2015, 06:22 AM
WillTRiker WillTRiker is offline Lay-out problem with mergefield that is not always to be printed Windows 7 64bit Lay-out problem with mergefield that is not always to be printed Office 2007
Novice
Lay-out problem with mergefield that is not always to be printed
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Lay-out problem with mergefield that is not always to be printed Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
SUM a single mergefield kawirider88 Mail Merge 1 09-29-2013 06:37 PM
2 page document printing problem, text from page 1 in layout of page 2 when printed laurawether45 Word 1 08-02-2012 07:03 AM
Lay-out problem with mergefield that is not always to be printed Substituting a value using MERGEFIELD CharlieVW Mail Merge 3 05-07-2012 12:11 PM
Mergefield date error michielvanderbiest Mail Merge 1 04-12-2010 11:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft