A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

WORD XP mail-merge FAILS using ACCESS query



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old November 22nd, 2004, 12:49 PM
SueMackay
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.