Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. | Mailmerge | |||
collate pages in mail merge vs mail merge being single document | Mailmerge | |||
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe | Microsoft Word Help | |||
mail merge doc with further linked/embedded mail merge docs not playing the game | Mailmerge |