Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-28-2012, 07:15 PM
lawlaw lawlaw is offline Can I have a dropdown list to choose from in mail merge? Windows 7 64bit Can I have a dropdown list to choose from in mail merge? Office 2007
Novice
Can I have a dropdown list to choose from in mail merge?
 
Join Date: Oct 2012
Posts: 12
lawlaw is on a distinguished road
Default Can I have a dropdown list to choose from in mail merge?

I am an attorney creating merge pleadings for clients. What I am doing is inserting client information into practice management software, which then merges it into Word. For more complex information, I am using merge rules within word. I am looking for something similar to the "ASK" command, but in a drop down formula.

For example, the question is "What parenting should Father have?". The dropdown options I want to choose from are:
1. Reasonable parenting time to the parent who does not have custody according to the Maricopa County Parenting time Guidelines; OR


2. according to the attached Parenting Plan; OR
3. Supervised parenting time but only in the presence of another person; OR
4. No parenting time rights to Father

Whatever option I choose would be inserted into the document. Is there a way?
Reply With Quote
  #2  
Old 11-29-2012, 02:36 AM
macropod's Avatar
macropod macropod is offline Can I have a dropdown list to choose from in mail merge? Windows 7 64bit Can I have a dropdown list to choose from in mail merge? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

That would require a formfield, and formfields are not compatible with mailmerge.

However, you could use an ASK field that prompts you to input a number (1-4), coupled with a formula field to evaluate the response and display variable output accordingly.

Alternatively, you could have a field in your data source where the corresponding values are stored, for automatic evaluation as the mailmerge executes. The advantage of this approach is that the data are then more readily accessible for review/revision.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-29-2012, 11:33 AM
lawlaw lawlaw is offline Can I have a dropdown list to choose from in mail merge? Windows 7 64bit Can I have a dropdown list to choose from in mail merge? Office 2007
Novice
Can I have a dropdown list to choose from in mail merge?
 
Join Date: Oct 2012
Posts: 12
lawlaw is on a distinguished road
Default

Macropod, would you be able to show me an example of the second and third options you mentioned?
Reply With Quote
  #4  
Old 11-29-2012, 04:47 PM
macropod's Avatar
macropod macropod is offline Can I have a dropdown list to choose from in mail merge? Windows 7 64bit Can I have a dropdown list to choose from in mail merge? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

See attached Demo.doc. It contains both a SET field that you might use if the data come from a field in your data source named 'Parenting Rights' and an ASK field that prompts the user for a choice. In either case, the same set of IF fields that follow these two would be used to generate the output. As it is, pressing Ctrl-A, then F9 will trigger the ASK field and inputting a number will cause the IF fields to do their thing.

Pressing Alt-F9 toggles the field code display on/off.


Note the the ASK field is limited in terms of what can be done to structure the questions, including an overall character limit, hence the amount of space padding within it.
Attached Files
File Type: doc Demo.doc (32.5 KB, 90 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I have a dropdown list to choose from in mail merge? mail merge address list disappeared janm Mail Merge 1 08-06-2012 11:41 PM
Populate dropdown list with data from Access table spw4000 Office 0 02-24-2012 05:22 AM
Change cell color everytime a value is selected in dropdown list angelica_gloria Excel 4 01-27-2012 06:47 PM
Can I have a dropdown list to choose from in mail merge? Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM
Dropdown list of email addresses J Partridge Outlook 1 01-13-2011 06:37 AM

Other Forums: Access Forums

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