#1   Report Post  
Posted to microsoft.public.word.newusers
ice[_2_] ice[_2_] is offline
external usenet poster
 
Posts: 1
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? gmax2006 Microsoft Word Help 1 March 28th 07 06:28 PM
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. Chris Green Mailmerge 5 October 8th 05 03:51 PM
collate pages in mail merge vs mail merge being single document Dan Schwab Mailmerge 2 September 14th 05 09:35 PM
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe F. Ferrer Microsoft Word Help 0 February 2nd 05 08:27 PM
mail merge doc with further linked/embedded mail merge docs not playing the game Rob Cowlard Mailmerge 3 January 8th 05 09:15 AM


All times are GMT +1. The time now is 09:48 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"