Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-17-2016, 02:14 PM
sfkHooper sfkHooper is offline Displaying FORMTEXT fields when merge fields are empty or null Windows 7 64bit Displaying FORMTEXT fields when merge fields are empty or null Office 2013
Novice
Displaying FORMTEXT fields when merge fields are empty or null
 
Join Date: Jan 2016
Posts: 3
sfkHooper is on a distinguished road
Default Displaying FORMTEXT fields when merge fields are empty or null

I have a merge document (Word 2013) that I want to distribute to customers and have them fill in the missing information. The merge document populates fields from our database but where we have missing entries, in the mobile phone number for instance, I want a formtext field to display, prompting action from the customer to complete.

I have tried using an IF statement:
{ IF { MERGEFIELD "Mobile Phone" } = "" { FORMTEXT } { MERGEFIELD "Mobile Phone"} }

As you might expect, if "Mobile Phone" has data, then it is displayed. But if the field is empty, then nothing is displayed. Other formtext fields not embedded within merge fields display correctly.



How can I display the formtext field conditionally?
Reply With Quote
 

Tags
merge formtext



Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying FORMTEXT fields when merge fields are empty or null Empty Fields in MS Word georgedy Word 1 12-21-2015 10:38 PM
Macro to keep formatted form fields after mail merge or replace text with formatted form fields jer85 Word VBA 2 04-05-2015 10:00 PM
Using fields to test on empty ? NobodysPerfect Word 4 10-11-2014 03:01 AM
Word 2010 - DOCX File with fields -> PDF with fields senglory Word 2 03-27-2012 10:10 AM
Displaying FORMTEXT fields when merge fields are empty or null Help with merge fields Chris182 Mail Merge 3 12-04-2011 07:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:32 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