#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Quote:
You can print that preview. If you need to save it as a document, set the merge status to a normal word document. This unlinks you from the database and leaves the current data filled in. If you want to do an actual merge, then you have to use the select recipients feature and check off who you want the merged documents to go to. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automaticly fill word document | Frogil | Word | 3 | 04-24-2012 06:06 AM |
Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248 | Joe Patrick | Word VBA | 2 | 01-30-2012 07:23 AM |
Word Fill-in form with Excel spreadsheet | karik | Word | 0 | 01-11-2010 08:45 AM |
word 03 fill in | DianaW | Word | 2 | 12-30-2009 06:02 AM |
Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |