I'm using Excel & Word 2003.

I'm trying to auto fill address fields within a word document from a contact
database in an Excel workbook.

I attach a copy of the Word doc (which will be saved as a template) and the Excel workbook for ease of understanding

The first cell of the address table needs to be able to draw data and create a drop down filter to select a name from the Customers tab of the Excel workbook. This in turn should auto fill the remainder of the address. If say, there is not a line 4 of the address, I would like to be able move the postcode to that cell so that there are no blank fields unless beneath the postcode.



I have been able to achieve this within the Invoices, Quotation and Worksheet tabs of Excel which read from the Customers tab, but I don't know how to achieve this within word.

Is this the best way to achieve my goal?

Can anyone help?

Attached Files

	Anthony Statement Letter TEST.doc (29.5 KB, 12 views)
	Plumbing & Heating TEST.xls (73.5 KB, 12 views)