Microsoft Office Forums This should be easy - check box

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2011, 01:14 PM
RIKIL RIKIL is offline This should be easy - check box Windows XP This should be easy - check box Office 2000
Novice
This should be easy - check box
 
Join Date: Jun 2011
Posts: 6
RIKIL is on a distinguished road
Default This should be easy - check box

I have an excel spreadsheet with a column that has a Y or N in it. If the column has a Y in the spreadsheet, I want a checkbox to be checked in my MS word 2007 document. But it doesn't seem that straight forward.

From the Mailings tab in Word, I open the 'Rules' item and select If..then..else. I get a box that wants field name (which shows properly), then it asks for Comparisonm I select Equal To. And in the Compare To field I can put Y but I am not sure how the box actually gets checked on the MS word document. My only choices are to insert some text, not take an action like check a box. Do I need to delete the existing checkbox that was created previously and add a new on?
Reply With Quote
  #2  
Old 06-28-2011, 03:38 PM
macropod's Avatar
macropod macropod is offline This should be easy - check box Windows 7 64bit This should be easy - check box 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

Hi Rikil,

To insert check boxes (via the SYMBOL field) in a mail merge document use an IF test coded along the lines of:
{IF{MERGEFIELD Check1}= x YES NO}
where the "YES" and "NO" in the field code are replaced with the appropriate Windings characters, via Insert|Symbol

Alternatively, you could use:
{SYMBOL {IF{MERGEFIELD Check1}= x 254 168} \a \f Wingdings}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 06-29-2011, 06:58 AM
RIKIL RIKIL is offline This should be easy - check box Windows XP This should be easy - check box Office 2000
Novice
This should be easy - check box
 
Join Date: Jun 2011
Posts: 6
RIKIL is on a distinguished road
Default

Hi Paul-

Thanks for the reply.

I like to think I am experienced with MS word as I have been using it and a lot of its features for a while but I am just not connecting the dots of what you are talking about.

I know how to insert a Symbol (from the Insert menu) but is there a specific one I need to choose? Do I just choose a box shaped symbol?

Also, as I mentioned in the original post, I am not sure where to put that formula. When I am on the Mailings tab, I select Rules | If...then...else I get a box that looks like this: http://imageshack.us/f/838/screenshot2277.jpg/

Not something I am thinking would take that formula. So that is why I am just not connecting the dots, would you elaborate a bit further?
Reply With Quote
  #4  
Old 06-29-2011, 05:13 PM
macropod's Avatar
macropod macropod is offline This should be easy - check box Windows 7 64bit This should be easy - check box 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

Hi Rikil,
Quote:
but I am just not connecting the dots of what you are talking about
It really isn't all that hard - simply go to wherever you want the checkboxes to appear, press Ctrl-F9 twice to create a nested pair of field braces (ie '{{ }}') and fill in/around them as shown for the first field - or press Ctrl-F9 thrice to create a nested trio of field braces (ie '{{{ }}}') and fill in/around them as shown for the second field. Use whatever your mergefield's name is in place of the 'Check1'.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 06-30-2011, 02:14 PM
RIKIL RIKIL is offline This should be easy - check box Windows XP This should be easy - check box Office 2000
Novice
This should be easy - check box
 
Join Date: Jun 2011
Posts: 6
RIKIL is on a distinguished road
Default

That has got me where I needed to be, thank you.
Reply With Quote
  #6  
Old 07-15-2011, 10:24 AM
RIKIL RIKIL is offline This should be easy - check box Windows XP This should be easy - check box Office 2000
Novice
This should be easy - check box
 
Join Date: Jun 2011
Posts: 6
RIKIL is on a distinguished road
Default

one more thing...I have been trying to use a nested if statement with this and can't seem to get it. I need something like this:

if field A = N and if field B = N, true, false

I just can't seem to get the syntax of this right in Word. Any help here?
Reply With Quote
  #7  
Old 07-15-2011, 04:07 PM
macropod's Avatar
macropod macropod is offline This should be easy - check box Windows 7 64bit This should be easy - check box 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

Hi Rikil,

Try a field coded as:
{IF {MERGEFIELD A} = "N" {IF {MERGEFIELD B} = "N" "True" "False"} "False"}
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #8  
Old 07-18-2011, 09:27 AM
RIKIL RIKIL is offline This should be easy - check box Windows XP This should be easy - check box Office 2000
Novice
This should be easy - check box
 
Join Date: Jun 2011
Posts: 6
RIKIL is on a distinguished road
Default

OK, I think that worked...just need to do more testing.

Two follow up questions:

Does the value I am looking for need to be in double quotes?

Is there any way to make the formula NOT case sensitive? I have a field that will show up properly on my form if I have "Corporation" in my spreadsheet but not "COrporation". Any way to get around that?

Thanks
Reply With Quote
  #9  
Old 07-18-2011, 04:30 PM
macropod's Avatar
macropod macropod is offline This should be easy - check box Windows 7 64bit This should be easy - check box 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

Hi Rikil,

If the expression being tested has spaces in it, then yes, you do need the docuble quotes. You also need them for any output expressions that have spaces in them.

As for case-insensitivity, use something along the lines of:
{IF {MERGEFIELD A \* Upper} = "CORPORATION" {IF {MERGEFIELD B \* Upper} = "N" "True" "False"} "False"}
Basically, the '\* Upper' switch converts the mergefield contents to upper-case, which alloes the comparison to be done on an all-caps basis.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #10  
Old 07-19-2011, 07:50 AM
RIKIL RIKIL is offline This should be easy - check box Windows XP This should be easy - check box Office 2000
Novice
This should be easy - check box
 
Join Date: Jun 2011
Posts: 6
RIKIL is on a distinguished road
Default

I feel I am sufficiently knowledgeable about mail merge now...more so than when I started. Thank you.

Do you have any references to the help you provided here? I tried to find a web site with answers to these questions but I wasn't about to find ONE site with all this info.
Reply With Quote
  #11  
Old 07-19-2011, 08:03 PM
macropod's Avatar
macropod macropod is offline This should be easy - check box Windows 7 64bit This should be easy - check box 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

Hi Rikil,

I'm not aware of any websites that cover all aspects - it's a pretty wide area once you start taking some of the more advanced issues into account. I've written a tutorial on Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version):
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
And that's just one small part of the mailmerge 'world'. Do read the tutorial before trying to use the mailmerge document included with it.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
This should be easy - check box Easy questions for VBA programmer regarding Word Templates gurp99 Word VBA 1 06-24-2011 06:26 PM
Looking for easy and quick way to draw on class notes "x-rays - image" Lacrosseboss18 PowerPoint 0 02-04-2011 01:21 PM
Three easy (certainly for experts!) Word-questions cindymiller Word 3 12-26-2010 02:18 AM
This should be easy - check box Windows Easy Transfer/Office 2007 Outlook known flaw thickhead Office 1 02-09-2010 08:36 PM
I need help creating an extra column EASY question :) Please soapage Word 2 03-16-2009 05:16 PM


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