Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2018, 10:59 AM
pmack315 pmack315 is offline Test Generator help with blanks and if/then statement Windows 7 64bit Test Generator help with blanks and if/then statement Office 2010 64bit
Novice
Test Generator help with blanks and if/then statement
 
Join Date: Apr 2018
Posts: 1
pmack315 is on a distinguished road
Default Test Generator help with blanks and if/then statement

I created a test generator using mail merge.



«QuestionID». «strQuestion»
«Option_A_ID» «Option_A»
«Option_B_ID» «Option_B»
«Option_C_ID» «Option_C»
«Option_D_ID» «Option_D»
Answer: «Answer»

For my exam, I have multiple choice, True/False, and Fill in the blank. I have had some success putting it together but IF/Then statements and Blanks are really kicking my butt.

Option_A_ID is "a." Option_B_ID is "b." Option_C_ID is "c." Option_D_ID is "d."

For True/False questions, I don't want Option_C_ID or Option_C to still. I was thinking: If Option_C is Blank, don't show Option_C_ID and suppress that line.

Same idea for Fill in the blank. If Option_A is blank, only show Option_A_ID and a "_____________________________________________ ____ ____".

Is there a way that I could do this?
Reply With Quote
  #2  
Old 04-10-2018, 10:02 PM
macropod's Avatar
macropod macropod is offline Test Generator help with blanks and if/then statement Windows 7 64bit Test Generator help with blanks and if/then statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

By default, mailmerges suppress blank lines. Is that not happening for you? Is each line terminated by a paragraph break?

Have you tried the Mailmerge Empty Space Suppression & Mailmerge Empty Line Suppression methods described in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum?:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge help, mail merge issue, mail merge; if; fill-in

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Test Generator help with blanks and if/then statement Counting Blanks in 1 Column and Non-Blanks in Another dogwood705 Excel 4 02-07-2015 08:45 AM
Test Generator help with blanks and if/then statement Random Name Generator knp11 Word 1 01-18-2015 11:41 AM
Test Generator help with blanks and if/then statement Need guidance on creating a Word doc generator mikeman Word VBA 1 10-26-2014 10:35 PM
Document Filename Generator for Referencing john.adams Word 10 03-26-2013 12:14 AM
Document Generator HJJ Word 0 08-12-2009 03:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 AM.


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