Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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



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 10:19 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