file management

[DJ]

I have an excel spreadsheet to track my quotes., I create my quotes in word for e-mailing and faxing. Can I connect the two programs together. My goal is to be able to search by quote # that I have created in an excel column and retreive the quote from word.

 

[Tushar Mehta]

Treat the XL spreadsheet as the data source. Then, in Word, create a
Mail Merge document (template) that uses the XL data as its data
source.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[DDM]

DJ, a hyperlink from your Excel spreadsheet to your Word document might do
the trick. Look up "Hyperlink Worksheet Function" in Excel (2000) help. Also
look up "Create a Hyperlink."

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I have an excel spreadsheet to track my quotes., I create my quotes in

word for e-mailing and faxing. Can I connect the two programs together. My
goal is to be able to search by quote # that I have created in an excel
column and retreive the quote from word.

 

[CLR]

I would recommend just doing the whole thing in Excel..........both the
quotes, and the database......

Vaya con Dios,
Chuck, CABGx3

I have an excel spreadsheet to track my quotes., I create my quotes in

word for e-mailing and faxing. Can I connect the two programs together. My
goal is to be able to search by quote # that I have created in an excel
column and retreive the quote from word.