Results 1 to 10 of 10
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mail merge problem. (office2000)

    I have a query and am trying to use it as a source for a mail merge document. When I try to open this query from word as data source, it displays an error message saying that the data source was unable to open. (I had the access program closed when I tried it so thats not why it happened) Can somebody help me overcome this? Microsoft web help doesn't help me at all so please don't turn me in that direction. <img src=/S/weep.gif border=0 alt=weep width=21 height=16>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: mail merge problem. (office2000)

    Remember that if it's a parameter query, you cannot use ODBC - you must use DDE in Access 2k. Also, have Access open shouldn't make any difference unless you open it exclusively.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mail merge problem. (office2000)

    I have two suggestions for possible answers. One is to use a text file exported from Access as your datasource and allow Access to limit the recordset produced based on the parameter query. The other is to use a straight query, no parameters, and filter the results from Word, since that is perfectly possible as well. I've always hated the overhead created when using Access as a source for a mail merge, so I long about resorted to exporting the relevant data to a tab-delimited text file and linking the merge documents to that instead.
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge problem. (office2000)

    <P ID="del"><FONT SIZE=-1>Post deleted by princess15s</FONT>

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge problem. (office2000)

    I've done what you told me to do charlotte, I've imported the contents of the query into a txt file and linked that as the data source to the mail merged document and it works. Thank you. But the only question I have is would that link last for long coz I've noticed in the past that I had to relink the data sources coz it kept on prompting that the data source was not found, what do you think causes this? Is there anything I can do to prevent this?

  6. #6
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge problem. (office2000)

    Same problem occurs when I tried to mal merge another query which has no parameter. Is something wrong with access or is it me? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mail merge problem. (office2000)

    I have no idea what it is that's giving you problems. I have no trouble creating a mail merge document and linking it to a saved parameter query. When I merge the document in Word, it prompts me for the parameter. From the way I understood your earlier posts, it wasn't working that way for you. Did you try linking to a regular saved select query (no parameters) and using the Query Options in the Mail Merge Helper to specify the filters for your mail merge? It would help if you could provide more specific information about the problem when you describe it.

    Linking to a text file can be a problem if you're deleting and recreating the text file. The best way around that is to create a mail merge template for the document and link that template to an existing datasource text file. Then, each time you *export* from Access, give the output file the same name as the only you originally created to set up the mail merge template. When you open a new document based on the mail merge template, it should already be linked to the appropriate file.

    You mentioned imported the text file from Access, but I have no idea of what you actually meant. Importing the data from Access would create a new file each time and you would have to relink it, I suppose. I've used this to generate customized fax documents sent from Word through WinFax pro and have never had any problems with the logistics of it.
    Charlotte

  8. #8
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge problem. (office2000)

    I undersatand what I have to do to link a txt file to a mail merged document, but I don't want to create too many files. All I want to do is create a link between a simple query and a document, which wouldn't open instance of access everytime I open the merged document. I know this can be achived by linking the source via ODBC, I have tried to do that and every time I tried, it gives me an error message saying that word couldn't merge with the data source.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mail merge problem. (office2000)

    Princess, it's *normal* for Word to open an instance of Access to do the mail merge. With Office 2000, that is an unobtrusive operation anyway, so what's your problem with it? If what you're trying to do doesn't work, try something that does. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> If you want to use a text file, then just give it the same name every time you create it. No matter how many times you do that, it's still only one text file.
    Charlotte

  10. #10
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge problem. (office2000)

    Thank you charlotte,
    Even though i don't like the idea of using a text file as the data source, Im gonna do it.
    thank you
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

Posting Permissions

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