Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2020, 05:26 PM
kjc kjc is offline Content Control to turn Merge Field on/off Windows 10 Content Control to turn Merge Field on/off Office 2019
Novice
Content Control to turn Merge Field on/off
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default Content Control to turn Merge Field on/off

In a Word mail merge document, can a named content control checkbox be used to show or not show a merged field?
Here's what I've tried without success:


{ IF "mycheckbox" <> 0 {MERGEFIELD "Engineer"} "" }
Reply With Quote
  #2  
Old 05-19-2020, 12:50 AM
macropod's Avatar
macropod macropod is offline Content Control to turn Merge Field on/off Windows 7 64bit Content Control to turn Merge Field on/off Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,497
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

In a word, no. Perhaps you could explain why you're trying to use a content control this way.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-19-2020, 04:16 AM
kjc kjc is offline Content Control to turn Merge Field on/off Windows 10 Content Control to turn Merge Field on/off Office 2019
Novice
Content Control to turn Merge Field on/off
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default

I'm attempting to automate an MS Word order form from one of our suppliers using mail merge along with data exported from our project database. The order form asks if the specifying engineer is in our sales territory and has a YES checkbox and an NO checkbox. If NO is selected, the user should enter the engineer company name and city in the form fields provided, otherwise leave them blank. We're not allowed to change the order form. Since we have the info in our database, it is always exported whether it is needed or not. But I don't want it to show on the form unless it is required.
Reply With Quote
  #4  
Old 05-19-2020, 05:54 AM
macropod's Avatar
macropod macropod is offline Content Control to turn Merge Field on/off Windows 7 64bit Content Control to turn Merge Field on/off Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,497
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

First you refer to content controls, now you refer to formfields. You can't use data entry formfields in a mailmerge.

For what you describe, it seems you would do better to use a simple ASK field instead of having two checkboxes, plus IF & FILLIN fields. See attached demo.
Attached Files
File Type: docx Prompt.docx (25.4 KB, 4 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-19-2020, 09:05 AM
kjc kjc is offline Content Control to turn Merge Field on/off Windows 10 Content Control to turn Merge Field on/off Office 2019
Novice
Content Control to turn Merge Field on/off
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default

Thanks. I think I'll just make the merge field hidden. It is so rare that this is an issue, it'll just have to stay a manual operation to unhide the engineer name.
Thanks again for the suggestion.
Reply With Quote
Reply

Tags
conditional, content controls, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Content Control to turn Merge Field on/off Calculated field using Content Control Dropdowns JNMBeaudesert Word 2 12-19-2019 12:11 AM
Content Control to turn Merge Field on/off Get image path from content control field - NO VBA possible thoerzer Word 5 10-10-2019 12:10 AM
Content Control to turn Merge Field on/off Show field shading in Content Control ajanson Word 3 08-15-2016 04:49 PM
Have Text Entered in Content Control / PreDefined Field Populate Field in Footer bzowk Word 1 04-14-2016 11:50 AM
Content Control to turn Merge Field on/off Adding auto text to end of content control field ksigcajun Word VBA 4 10-13-2014 05:37 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:13 PM.


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