I
ice
I have a bit of an issue with a Mail Merge Document. We have been
using the same Document for 3+ years.
The document was linked to an Excel sheet on a server. The data on
the server was recently "Reorganized"
Originally when the document was opened, a message would apear that an
sql command was going to run
"Select * from s:\data\excelfiles\file.xls" Data from your database
will be placed in the document. Do you want to continue?"
I click yes, the excel file opens and all is well.
Since the reorganization I had open a new data source as the excel
file had moved, I pointed it to the new source saved. When I open
the Document now I get Sql command "Select * fron 'Sheet1$' but the
excel file does not open. (the merge functions but the excel file
does not open)
I would really like to the Word Document work as it had always in the
past, show me the name of the file and then open the excel file too,
as I would update the excel file at that time also. Is there a place
where I can change select statement?
Thanks
ICE
using the same Document for 3+ years.
The document was linked to an Excel sheet on a server. The data on
the server was recently "Reorganized"
Originally when the document was opened, a message would apear that an
sql command was going to run
"Select * from s:\data\excelfiles\file.xls" Data from your database
will be placed in the document. Do you want to continue?"
I click yes, the excel file opens and all is well.
Since the reorganization I had open a new data source as the excel
file had moved, I pointed it to the new source saved. When I open
the Document now I get Sql command "Select * fron 'Sheet1$' but the
excel file does not open. (the merge functions but the excel file
does not open)
I would really like to the Word Document work as it had always in the
past, show me the name of the file and then open the excel file too,
as I would update the excel file at that time also. Is there a place
where I can change select statement?
Thanks
ICE