Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Leamington Spa, Warwickshire, England
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Error (2003)

    I have several data sources set up in Excel. The appropriate fields have been inserted into a word document. This datasource was then queried on. However when I go and try to do another merge when I open the main document I get a
    "opening thie document will run the following SQL
    select * from sheet1 where field = x
    data will be placed in your document do you want to continue?"

    At home (xp home) if I say no. i have to go find the data source and insert insert all the merge fields again
    If I say yes it will insert the names and addresses

    At work (xp professional) if i say no, i have to go find the data source and insert insert all the merge fields again
    If I say yes it seems to be Ok and will let me performanother query.

    Am I doing something stupid? i have been using Mail merge for years and know what I am doing. Someone said I was moving the datasource but i'm not. Ican't understand why suddenly i can't query. I have tried making sure that in select recipients no queries are appearing before I close the main document but it still won't work.

    As I use this data source on a daily basis it would be quite usful t see if others have had this happen.

    Michelle

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Mail Merge Error (2003)

    See <A target="_blank" HREF="http://support.microsoft.com/?kbid=825765">You receive the

Posting Permissions

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