I'm setting up an account list for a symposium. I'm using a simple excel document that merges to a word dokument. The word dokument is then to be printed so every user can sign his account. All the accounts are of the format user.001 etc. Roughly half of the accounts also has a person tied to them, the rest will appear when the symposium starts.
Now I would simply have it that where the PersonName cells are empty, there should instead be a line to write your name by hand. So far I just filled every empty cell with a long line of underscore like this ______________________.
Is there a smarter way, like making Word detect empty cells and replace them with a line?
Best Answer
You can use an IF statement in the Name field. Something along the lines of
Note that the { } signs are not typed but denote Word fields. You can insert a field with Ctrl - F9