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

    Mail merge (Office 2k)

    Hi y'all,
    I've got a teenie weenie problem. I have tried to mail merge a document with a access query but when I try to open the data source it displays a error message saying: word was unable to open the data source. why is this?
    Thank you..

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Mail merge (Office 2k)

    Is the query sitting in a .mde or a .mdb file?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Mail merge (Office 2k)

    an mdb file. I'm trying to link via ODBC.
    The query I'm trying to link extracts data from few tables, do you think thats the problem?

  4. #4
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge (Office 2k)

    Check this MS knowledge base page:<A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q224/0/56.ASP>http://support.microsoft.com/support/kb/ar...s/Q224/0/56.ASP</A> It covers many possible causes for what you describe, plus there is a download from Microsoft that will give you more details for many Office2000 error messages(Look for "Customizable Alerts" on the above link). <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

    Edited by Charlotte to activate link

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

    Re: Mail merge (Office 2k)

    This can happen for a variety of reasons, not all of which are covered by Microsoft documentation. In particular, if you have Access security active, things can get sticky. For what ever reason, Word will often try to start a new instance of Access. In fact, this will always happen if you change the application name in the Tools/Startup dialog box to something other than Microsoft Access. Another reason is if the query doesn't return any records. Mail merge is a great tool, but it can also be a real pain in the neck.
    Wendell

  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 (Office 2k)

    Thank you Willyboy, I've downloaded the software but I still have no idea on what Im doing wrong here! <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>
    Hi Wendell,
    Mine doesn't open instance of access coz its linked via ODBC instead of ODE and I have got data in the table.
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20> I really don't know what is wrong. <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

  7. #7
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge (Office 2k)

    I have some mail merge letters (Word docs) that are linked through Access, which contains linked tables (ODBC). The actual tables exist on an IBM mainframe. When I open any of these documents, Access also opens, and I get a logon dialogue box for userid and password. Are you required to log on in order to view the results of your query? Are you trying to open the Access query as your mail merge datasource, or are you trying to open the tables through ODBC? In other words, in Word, are you choosing your Access mdb file as the datasource? <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Mail merge (Office 2k)

    >>The query I'm trying to link extracts data from few tables, do you think thats the problem?<<

    Shouldn't be. You might want to ask your question over in the Word Lounge.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Mail merge (Office 2k)

    Don't give up just yet! Is it possible that you are trying to use a parameter query to get your data for the merge? If so, that's one thing that doesn't work, as ODBC doesn't give you the ability to respond to any kind of prompt for a parameter as a criteria. In point of fact, ODBC works best in most cases with tables. It gets kind of ugly in Access 2002 however, as the default is ODEDB.

    Try linking to just a table to start with, and see if you can make that work.
    Wendell

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge (Office 2k)

    I find it much better to run 'transfertext' to a .txt file and then 'runapp' (or shell) to open the Word file which is merged with the specific .txt file. Otherwise I always found that Word tried to open Access again and all sorts of little annoyances occurred. You can do it with a macro or code whichever is easier for you.
    Peter Herworth

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge (Office 2k)

    I've found that starting from the source is the easiest solution. I hope this answer is what your looking for, I am not sure. But If I want an Access query to be merged to Word to use in a Mail Merge...I start with the Access query IN ACCESS...makes a big difference...
    1. Click once on your access query in Access to highlight it.
    2. Look on the Standard toolbar for a Big Blue W Icon, and click on it.
    3. Choose "Merge to Word", and when the next dialog comes up, say to Link to either an existing Document that you have open, or a brand new one if you haven't started your letter in word yet.
    4. When you click the Ok button, Word will open, and then likely Minimize itself to the Taskbar.
    5. Click on the Word Button on the Taskbar to maximize it, and you will see a new mailmerge toolbar already in place at the top of the screen, and the first icon on it will allow you to pick your fields from the ones you have in your Access query.
    6. Any changes in your Tables in the Access Database of course reflect in your query, which will also reflect now in your Word document.


    Hope this helps
    Nannette Padgett <img src=/S/cool.gif border=0 alt=cool width=15 height=15>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Mail merge (Office 2k)

    I am trying to open an access query via ODBC willyboy, and I do have parameters in this query Wendell Bell. I

Posting Permissions

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