Merge from Access to Word

K

Kelly

I am attempting to do a mail merge from an Access Query to Word (Office 2007)

When I view the query in Access, it contains several records. When I do
the Mail Merge in Word, the record source appears to be empty. I've seen
responses on how to fix this problem in older versions of Office, but not in
2007.

It's particularly frustrating because I copied this query and changed only
the criteria (retrieving data from one state vs. another state). The first
version of the exact same query works fine.
 
K

Kelly

Just out of curiousity, I tried the merge in Publisher. Same problem.

Query1 works fine, Query2 shows up empty. They are the exact same query
except for a change in criteria. Both return approximately the same number
of records in Access.
 
K

Karen

I am having the same exact problem on AC2007. The merge still works
perfectly in AC2000 but I can't see the records or successfully complete the
merge in AC2007. Let's hope we get some helpful advice on fixing it.
 
P

Pieter Wijnen

not very helpfull, but there's a reason why I'll not use either vista or
o'2007 for a long time yet
I thunk they'll go down in history as yet another access 95 / windows ME

dsm

Pieter
 
K

Karen

I simply recreated my form in Access and added the Merge command button.
Those on AC2007 are able to view the data on the form and the merge works
perfectly now. I don't know why it didn't work on the old form.

Kelly, maybe you could recreate your data source and try the merge again...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top