Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    378
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Merge warn that opening doc will run SQL command (OfficeXP, WinXP)

    Hi

    We're upgrading from Office97/NT to OfficeXP/WinXP. We have a group of merge documents developed under Office 97. When you open any of these documents, the following message appears:
    <pre> Opening this document will run the following SQL command:
    SELECT * FROM c:eodlettersmail_mergemerge.txt
    Data fromo your database will be placed in the document. Do you want to continue?
    </pre>


    The file "c:eodlettersmail_mergemerge.txt" is the merge document's data file.

    Does anyone know why this appears, and how to stop the message appearing?

    Thanks
    Dale

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    378
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Merge warn that opening doc will run SQL command (OfficeXP, WinXP)

    Hi

    I may have found the solution myself. I'll try this MS link.

    Thanks
    Dale

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Merge warn that opening doc will run SQL command (OfficeXP, WinXP)

    Thanks for posting the solution, it could be a great help to anyone who comes across your request in a search.

    StuartR

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge warn that opening doc will run SQL command (OfficeXP, WinXP)

    Hi Dale,

    It could be more simple than you think. Just about universally if you upgrade from 97 to either 2002 or 2003 you need to re-point to the data source for any merge documents.

    Just open the master document and re-select the data source and everything should be fine.

    cheers

  5. #5
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge warn that opening doc will run SQL command (OfficeXP, WinXP)

    Hello Hans and Karen:

    Concerning the following:

    "Opening this document will run the following SQL Command", select from the "Office Address List"

    I have just finshed two different types of merge letters for a client, this basically says do you want to run the SQL command which should have the name, surname, company name etc; if I need to resuse any of the letters again, I answer yes.

    This way when I go to use the recep list, I will not have to start from scratch. Is there something that I should be doing different?

    Thanks dillon65

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •