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..

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>

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.

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>

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.

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

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.