If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
WORD XP mail-merge FAILS using ACCESS query
I suddenly have a problem mail-merging labels and letters in WORD from an
ACCESS Database. I am guessing it is an incompatible problem but I just can't seem to fix it - any ideas would be really appreciated. I can get round the problem by exporting from Access to Excel then merging into Word - but of course that is a bit crazy - and the records are not "up-to-date" from the latest Query. I have also "Googled" the problem to no avail. I was using Word 2000 and Access 2000 - during that time - the Access database (with just under 1,000 records) merged beautifully with Word - and I have lots of documents saved in Word with "permanent" links to certain Queries - so that I can print out labels and sometimes merge letters. I have recently upgraded to Office XP and am up-to-date with all the patches(and come to think about it - also 'successfully' downloaded SP2 for Windows XP Home too). I have tried my database converted from Access 2000 to Access 2002 (which apparently 'is' XP) and I have also retained the database in the 2000 format - but either way..... Now I have a problem - HOWEVER, all my original mail-merged Word documents still work successfully (thank goodness) - its only brand new mail-merges that I create which go wrong........ Any new mail-merge I attempt now - ends up with the recipients list "empty" - I either get a warning saying the "data records were empty" and/or "no recipients were found because the list was empty" - when all the time - the various Queries I have tried linking to - definitely have records in them - and they successfully Export to Excel and in fact a Label Report within Access itself works fine too. So it is somehow Word not reading the Query successfully I guess. The only thing I can see as different comparing a "new" unsuccessful merge with an "old" successful mail-merge is that if I look at the Mail-merge Wizard in Word XP - the successful OLD version states it is using: "database name" QUERY query-name whereas the new style states: [query-name] in "database-name" (showing query name first - yet not mentioning the word QUERY as above). But I've no idea whether I can ever change that? Has anyone else experienced these problems? has anyone an idea? Sue I suddenly have a problem mail-merging labels and letters in WORD from an ACCESS Database. I am guessing it is an incompatible problem but I just can't seem to fix it - any ideas would be really appreciated. I can get round the problem by exporting from Access to Excel then merging into Word - but of course that is a bit crazy - and the records are not "up-to-date" from the latest Query. I have also "Googled" the problem to no avail. I was using Word 2000 and Access 2000 - during that time - the Access database (with just under 1,000 records) merged beautifully with Word - and I have lots of documents saved in Word with "permanent" links to certain Queries - so that I can print out labels and sometimes merge letters. I have recently upgraded to Office XP and am up-to-date with all the patches(and come to think about it - also 'successfully' downloaded SP2 for Windows XP Home too). I have tried my database converted from Access 2000 to Access 2002 (which apparently 'is' XP) and I have also retained the database in the 2000 format - but either way..... Now I have a problem - HOWEVER, all my original mail-merged Word documents still work successfully (thank goodness) - its only brand new mail-merges that I create which go wrong........ Any new mail-merge I attempt now - ends up with the recipients list "empty" - I either get a warning saying the "data records were empty" and/or "no recipients were found because the list was empty" - when all the time - the various Queries I have tried linking to - definitely have records in them - and they successfully Export to Excel and in fact a Label Report within Access itself works fine too. So it is somehow Word not reading the Query successfully I guess. The only thing I can see as different comparing a "new" unsuccessful merge with an "old" successful mail-merge is that if I look at the Mail-merge Wizard in Word XP - the successful OLD version states it is using: "database name" QUERY query-name whereas the new style states: [query-name] in "database-name" (showing query name first - yet not mentioning the word QUERY as above). But I've no idea whether I can ever change that? Has anyone else experienced these problems? has anyone an idea? Sue |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word mail merge using Access. Formatting wrong. | Niddala100 | General Discussion | 3 | September 10th, 2004 02:46 AM |
Mail merge to Word from Access 2000 | Anthony | General Discussion | 1 | August 4th, 2004 12:35 PM |
Word 2002 Mail Merge with Access database | Nancy | Mailmerge | 1 | June 23rd, 2004 10:33 AM |
Access 2000 to 2003 mail merge to word | JJ | Running & Setting Up Queries | 1 | June 23rd, 2004 06:41 AM |
Word mail merge with Excel data | Peter Jamieson | Mailmerge | 1 | April 26th, 2004 07:30 PM |