#1
|
|||
|
|||
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.. |
#2
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Making items (text, pictures, etc.) static on page | Jeremiahts | Word | 3 | 04-07-2011 09:54 PM |
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 |