L
LisaLev
I am experienced at using Access data to merge to Word documents - letters
and mailing labels. However, I'm not real good at the lingo, so bear with me.
For some reason, sometimes Word doesn't "see" the access data, and access
doesn't "see" the word document. Here's what I mean. I create a select
query in access. I run and use Tools, Office links, Merge with Word. Then I
choose Merge with an existing document. I find my document (which at this
point is just text, no merge fields have been added yet). Up pops a dialog
box "Select Table", and shows two manually-created tables in Campaign.mdb. I
don't want that database, so I change to Transaction.mdb. It then somehow
forgets that it came from the query, and proceeds to pull in every piece of
data from that database, not my query. So in my Word Mailmerge helper, I
"select a different list", and go back and find transaction.mdb. It brings
up two manually-created table list, and some queries, but they're not
complete. Where is the query I started with? And I can't do the reverse -
go from Word back to my Access query, because it can't see it that way
either. What's the deal??
I know that I could probably make it make-table query and use that data, but
I'd rather not, because I'm trying to make this as foolproof as possible for
another user.
and mailing labels. However, I'm not real good at the lingo, so bear with me.
For some reason, sometimes Word doesn't "see" the access data, and access
doesn't "see" the word document. Here's what I mean. I create a select
query in access. I run and use Tools, Office links, Merge with Word. Then I
choose Merge with an existing document. I find my document (which at this
point is just text, no merge fields have been added yet). Up pops a dialog
box "Select Table", and shows two manually-created tables in Campaign.mdb. I
don't want that database, so I change to Transaction.mdb. It then somehow
forgets that it came from the query, and proceeds to pull in every piece of
data from that database, not my query. So in my Word Mailmerge helper, I
"select a different list", and go back and find transaction.mdb. It brings
up two manually-created table list, and some queries, but they're not
complete. Where is the query I started with? And I can't do the reverse -
go from Word back to my Access query, because it can't see it that way
either. What's the deal??
I know that I could probably make it make-table query and use that data, but
I'd rather not, because I'm trying to make this as foolproof as possible for
another user.