Merge excel info into word letter.
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.
|