(Using Word 97)
I have an Excel document with various fields, and a Word document that is
a contract. What I need to do is create a macro that merges one row of the
excel data in the contract, then saves the document in the format
“sales_id-customer#”, which are two of the data fields in the excel sheet.
So I was wondering: Is there a way to create a macro in which one merges
specified data, then has the macro save the document according to fields
from the mail merge document, i.e. in this case, the “sales_id” and
“customer#” fields?