Microsoft Office Forums Merge not Displaying as Coded

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2014, 01:49 PM
Dmo Dmo is offline Merge not Displaying as Coded Windows 7 64bit Merge not Displaying as Coded Office 2013
Novice
Merge not Displaying as Coded
 
Join Date: Jul 2014
Posts: 3
Dmo is on a distinguished road
Default Merge not Displaying as Coded

Hello,

I have a field in a database that is a picklist with 4 values. Based on those values I wanted to have certain text appear but cannot seem to have displayed correctly when testing. I am using the If...Then logic but this does not seem to be working for me.



I have attached the sample of If Then logic being attempted.

Any guidance or insight is greatly appreciated.

Many thanks,

Derek Morrison
Attached Files
File Type: docx Mail Merge Sample for Forum.docx (12.3 KB, 1 views)
Reply With Quote
  #2  
Old 07-22-2014, 09:35 PM
macropod's Avatar
macropod macropod is offline Merge not Displaying as Coded Windows 7 32bit Merge not Displaying as Coded Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The reason your field doesn't work is that the embedded IF tests are created using ordinary, typed, braces, instead of field braces created via Ctrl-F9. They also lack the pairing of the opening and closing braces that true field braces would employ, so it's not possible to decipher what your intended field logic is. Furthermore, you don't need either the italics or the MERGEFORMAT switches for the fields to work and your last test seems pointless (it outputs nothing in either case).
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 07-23-2014, 07:17 AM
Dmo Dmo is offline Merge not Displaying as Coded Windows 7 64bit Merge not Displaying as Coded Office 2013
Novice
Merge not Displaying as Coded
 
Join Date: Jul 2014
Posts: 3
Dmo is on a distinguished road
Default Thank you

Hello macroprod,

Many thanks for your speedy and clear response. My mistake is that I expected when within the main CTRL+F9 logic portion that keyed in brackets would be noted accordingly. Your corrections were most helpful in finding my errors.

All is working as expected thanks to you but was hoping for a follow-up question if you had time. I have included a sample of the end product and as you can see there is an extra space when the text, if applicable, would be placed. Would you be able to provide insight into how to remove this extra row while stillkeeping text, when present, on its own line? I have included the section of logic as well.

I will address the MERGEFORMAT as you mentioned just making incremental changes to track if issues.

Many thanks,

Derek
Attached Files
File Type: docx If Then_Corrected.docx (12.3 KB, 3 views)
File Type: docx NOTICE TO QUIT FOR NONPAYMENT OF RENT.docx (14.6 KB, 2 views)
Reply With Quote
  #4  
Old 07-23-2014, 03:33 PM
macropod's Avatar
macropod macropod is offline Merge not Displaying as Coded Windows 7 32bit Merge not Displaying as Coded Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I'm not sure which 'extra space' you mean. If you mean there's an empty paragraph where the text would otherwise go, the solution is to move the paragraph break into the field, so it too becomes part of the conditional content.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 07-24-2014, 01:38 PM
Dmo Dmo is offline Merge not Displaying as Coded Windows 7 64bit Merge not Displaying as Coded Office 2013
Novice
Merge not Displaying as Coded
 
Join Date: Jul 2014
Posts: 3
Dmo is on a distinguished road
Default Thanks again

Hello Paul,

Yes. I am referring to the extra space where the text would place if met qualifier. Trying to figure out how to delete space so document looks proper when text is not there. Afraid I am new to the Word logic and I am unclear on how to complete.

I will research and see if I can locate a How To doc on working with If logic


Many thanks,

Derek
Reply With Quote
  #6  
Old 07-24-2014, 03:24 PM
macropod's Avatar
macropod macropod is offline Merge not Displaying as Coded Windows 7 32bit Merge not Displaying as Coded Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See attached.
Attached Files
File Type: docx attachment.docx (17.1 KB, 6 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge not Displaying as Coded Displaying notes for others jb1 PowerPoint 1 01-16-2013 03:15 AM
Why is the TOC displaying as a code? ponomariov Word 1 09-28-2012 03:13 PM
Word 2007 Mail Merge not displaying Address3 JeffBarker Mail Merge 0 09-13-2011 08:53 AM
mail merge queries not displaying donwalt Mail Merge 0 09-05-2010 02:41 PM
Merge not Displaying as Coded help to convert swf to avi for displaying in ppt? Frederick PowerPoint 1 09-13-2009 08:10 PM


All times are GMT -7. The time now is 04:01 AM.


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