Discussion Locked

Excel and Word

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

(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?

3 replies

by leighr

Have you investigated the mail merge feature? It could create the document for you. I don't have a handy macro for saving the file though.

This discussion is closed to new replies.