Mail merge (Office 2k)

Topic

New Reply

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

Reply | Quote

Replies

Is the query sitting in a .mde or a .mdb file?

Reply | Quote

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?

Reply | Quote

Check this MS knowledge base page:http://support.microsoft.com/support/kb/ar…s/Q224/0/56.ASP 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).

Edited by Charlotte to activate link

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

Thank you Willyboy, I’ve downloaded the software but I still have no idea on what Im doing wrong here!
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.
I really don’t know what is wrong.

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote