Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-10-2018, 10:59 AM
pmack315 pmack315 is offline Windows 7 64bit Office 2010 64bit
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
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

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?:
http://www.msofficeforums.com/mail-m...ps-tricks.html
__________________
Cheers,
Paul Edstein
[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
Counting Blanks in 1 Column and Non-Blanks in Another dogwood705 Excel 4 02-07-2015 08:45 AM
Random Name Generator knp11 Word 1 01-18-2015 11:41 AM
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


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft