Mail merge is one of the most useful features of Microsoft Word when wanting to send personalized letters, documents or e-mails to people you have stored in an Excel sheet. Let me show you how to use it.
When you want to copy the result of the cell to another cell in Excel, the target displays an invalid references error messag. This error can be avoided by copying cell value into target cell and not the whole formulas.
