Easily accomplished. Enter a formula in the desired cells on your proposal
that reads like this:
='[AddressBook.xls]Sheet1'!$B$3
Do this for each field and make sure to include the full path name to your
address book xls file.
(ie: c:\Microsoft\Excel\AddressBook.xls) in the formula.
--
Regards...
"Sarahbkelly" wrote:
In my business- I type many proposals in a day to my customers. I have the
proposal form as well as my address book saved as Excel files. Is there a way
to link my address book to my proposal so information such as address, phone
#, and etc are automatically imput?
|