Word: Search and fill from Excel
We have form letters that we send based on certain criteria. I would like to populate information in the form letter from an Excel file, but only for specified customers.
I would like to fill fields in a Word document from an Excel database (large spreadsheet). I want to enter a key field such as account# in the Word document, and have it find the matching line in Excel and fill into Word data from that line, customer name, address, ...
Ideas on how I can best achieve this result?
|