Hyperlink address fields from Excel
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?
|