While I've found some information on this, nothing has worked for me so far, so I'm hoping that an expert here can help me. We have an Excel spreadsheet that contain 700+ rows of Attorney names and their active client/matters. We would like to use Word's mail merge, to send one email message per attorney that displays all of the attorney's Active matters.
Please see the attached for a sample of the layout of the data.
I know that we could use Access, but we'd really like to use Word if possible.
Thanks in advance.