Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2011, 06:29 AM
kbranden kbranden is offline Merge Fields and Static Text Windows 7 64bit Merge Fields and Static Text Office 2007
Novice
Merge Fields and Static Text
 
Join Date: Jun 2011
Posts: 2
kbranden is on a distinguished road
Default Merge Fields and Static Text

Hey All, I have some labels I am creating which the data is pulled from SQLServer. I am using Avery 5262 which are 2 columns and 7 rows (14 labels in all)on each page and here is the problem I am having.

On each label there is a combination of static text and dynamic text (pulled from the database). It looks something like this..

Proj #: <<ProjectNumber>> File: <<File>>
Index1id: <<PlanIndex>> RID: <<ID> CAD: <<CAD>>


ok, the problem is that lets say you filter the records to only have 1 record and then try to print. The first label is correct, but all the other 13 labels have the static text still on them. How do you tell Word to IGNORE the other labels on the page and not print the static text if no record exists? Surely there is an option somewhere?

Basically, this is how the label reads..

«Description»
Proj #: «ProjectNumber» File: «File» Drawer: «Drawer»
Index1id: «PlanIndex» Rid: «ID» CAD: «CAD»

and the others are like this..



«Next Record»«Description»
Proj #: «ProjectNumber» File: «File» Drawer: «Drawer»
Index1id: «PlanIndex» Rid: «ID» CAD: «CAD»

Thanks..


Reply With Quote
  #2  
Old 06-15-2011, 09:02 AM
kbranden kbranden is offline Merge Fields and Static Text Windows 7 64bit Merge Fields and Static Text Office 2007
Novice
Merge Fields and Static Text
 
Join Date: Jun 2011
Posts: 2
kbranden is on a distinguished road
Default

Although I haven't received any replies yet, I have solved this issue to the extent of fixing the issue.

Solution that worked for me..
I created a 'view' in the database that concatenates the static text to the data itself and connected the merge file to the view instead of the table. I then used these fields as my merge fields and all fields are now dynamic in the merge file. After filtering, I now do not have any labels that are generated with static text if no record exist for that label.

Cheers.. hope this helps someone else.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Fields and Static Text Making items (text, pictures, etc.) static on page Jeremiahts Word 3 04-07-2011 09:54 PM
Merge Fields and Static Text Mail Merge truncating 'some' of the text fields......Not sure what to do sssb2000 Mail Merge 5 09-26-2010 09:40 AM
Mail Merge Fitting Text to Fields frnk4760 Mail Merge 1 05-18-2010 04:51 PM
Merge fields & Drop down menu's ShadeTree Word 0 03-09-2010 08:19 AM
Word not highlighting conditional Merge fields Dunce Mail Merge 0 02-15-2010 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 AM.


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