I am trying to set up a word letter that will use info from an excel spreadsheet. I have no problems putting in straight info but I have a problem with using an "if" statement to select info based on a check or lack of a check in an excel cell.



I have a cell that is checked if something is to be selected and is left blank if it is not to be accepted. I need to be able to put into the letter the contents of another cell and the statement "has been accepted" or "has not accepted" based on a check or no check in a cell.

Can anyone lay out this for me and help me to make it work in the merged letter?

Thank you so much for your assistance.

Hi curatorfm,

To use an IF field this way, you can code the field like:
{IF{MERGEFIELD CheckState}= "X" {MERGEFIELD ExtraText}}
or:
{IF«CheckState»= "X" «ExtraText»}
where 'CheckState' is the name of the mergefield used to determine the check status, 'X' is the field value that toggles it 'checked' and 'ExtraText' is the name of the field containing the additional text.

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. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]