Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I use an "IF" statement in Mailmerge?
I've got an Excel spreadsheet for Asset management with columns for different
features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a form letter during a mailmerge is a certain column contains "TRUE", but have been unnable to do so. |
#2
|
|||
|
|||
How do I use an "IF" statement in Mailmerge?
Hi Mia,
If you select your existing mailmerge field, which probably looks something like: «AssetFeature» and Press Ctrl-F9, you'll get: { «AssetFeature» } If you then fill in between the braces so that you've got: {IF«AssetFeature»= "TRUE" X "FALSE"} that should give the result you're after. Cheers "Mia" wrote in message ... I've got an Excel spreadsheet for Asset management with columns for different features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a form letter during a mailmerge is a certain column contains "TRUE", but have been unnable to do so. |
#3
|
|||
|
|||
How do I use an "IF" statement in Mailmerge?
Try
{IF«AssetFeature»= "TRUE" "X" "FALSE"} -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "macropod" wrote in message ... Hi Mia, If you select your existing mailmerge field, which probably looks something like: «AssetFeature» and Press Ctrl-F9, you'll get: { «AssetFeature» } If you then fill in between the braces so that you've got: {IF«AssetFeature»= "TRUE" X "FALSE"} that should give the result you're after. Cheers "Mia" wrote in message ... I've got an Excel spreadsheet for Asset management with columns for different features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a form letter during a mailmerge is a certain column contains "TRUE", but have been unnable to do so. |
#4
|
|||
|
|||
How do I use an "IF" statement in Mailmerge?
Or:
{IF«AssetFeature»= TRUE X FALSE} You don't need the quotes unless the strings have spaces in them ... Cheers "Charles Kenyon" wrote in message ... Try {IF«AssetFeature»= "TRUE" "X" "FALSE"} -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "macropod" wrote in message ... Hi Mia, If you select your existing mailmerge field, which probably looks something like: «AssetFeature» and Press Ctrl-F9, you'll get: { «AssetFeature» } If you then fill in between the braces so that you've got: {IF«AssetFeature»= "TRUE" X "FALSE"} that should give the result you're after. Cheers "Mia" wrote in message ... I've got an Excel spreadsheet for Asset management with columns for different features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a form letter during a mailmerge is a certain column contains "TRUE", but have been unnable to do so. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge Query - Works in Access; fails in Word | Mailmerge | |||
Trying to suppress Select Table box in Excel-Word mailmerge | Mailmerge | |||
Using If statement in mailmerge document | Mailmerge | |||
Included Property in Word 2003 MailMerge | Mailmerge | |||
Using MAILMERGE fields within HYPERLINK fields for Merge to Email | Mailmerge |