Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2010, 04:27 AM
BongoBill BongoBill is offline Hyperlink address fields from Excel Windows 7 Hyperlink address fields from Excel Office 2003
Novice
Hyperlink address fields from Excel
 
Join Date: Apr 2010
Posts: 1
BongoBill is on a distinguished road
Default 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?
Attached Files
File Type: doc Anthony Statement Letter TEST.doc (29.5 KB, 10 views)
File Type: xls Plumbing & Heating TEST.xls (73.5 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink outlook ram Outlook 0 11-10-2009 11:44 AM
Hyperlink address fields from Excel Hyperlink error help JENI Excel 4 05-08-2009 07:11 AM
Hyperlink ltvjim Outlook 0 03-28-2007 10:28 AM
hyperlink scuba32 Word 0 08-24-2006 07:15 AM
Trying to insert hyperlink to excel file into Outlook KarenE Outlook 0 05-08-2006 12:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft