file management

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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


DJ said:
I have an excel spreadsheet to track my quotes., I create my quotes in
Click to expand...
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.
 
I would recommend just doing the whole thing in Excel..........both the
quotes, and the database......

Vaya con Dios,
Chuck, CABGx3



DJ said:
I have an excel spreadsheet to track my quotes., I create my quotes in
Click to expand...
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.
 
Back
Top