Okay, I can live with those solutions.

That's essentially why I want to add a comment to the document: I want to
advise the user on precisely what they'll have to do next year when the
generate the next batch of cards. That user will likely be me and I won't
remember what I need to do by next week, let alone a year from now. If the
user is someone else, that makes the comment even more necessary ;-)

--
Rhino

"Suzanne S. Barnhill" wrote in message
...
Graham has dealt with the first issue; for the second, the only solution I
know of is to update the data source as needed. That is, for now, you use
the Open Data Source button on the Mail Merge toolbar to link the document
with Members2006. Next year, you open the document normally, then use Open
Data Source to change the source to Members2007. FWIW, the dialog you're
getting should give you the option of finding a new data source, but if it
doesn't, then you just have to remove the current one and then open a new
one.

Alternatively, you call the data source Members and link that to your
document. At the end of the year, you archive that file as Members2006 and
create a new Members data source that will automatically be linked to your
mail merge main document because Word is looking just at the file name,
not
whether it's the same file of that name that it looked for in the past.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"Rhino" wrote in message
...
I have a document that I wrote to produce a set of labels and it does a
mail
merge. The merge works fine and the labels come out perfectly. I just
want
to understand one thing.

Whenever I open the document, I get a warning message:

================================================== ============
"Opening this document will run the following SQL command:

SELECT * FROM `Members2006` ORDER BY `SequenceNumber` ASC

Data from your database will be placed in the document. Do you want to
continue?

(YES) (NO)
================================================== ============

When I press YES, I get a Microsoft Word dialog that says:

Membership_Cards.doc is a mail merge document. Word cannot find its data
source, C:\..\My Data Sources\Members.mdb.

(Find Data Source...) (Options...)

If I click on Options..., it offers to "Remove Data/Header Source" or
"Remove All Merge Info".

Neither of those is quite what I want to do.

My document is creating membership cards for my club and I want the
document
to point to a data source whose name includes the current year. For
example,
in 2006, I want the document to open a table called Members2006 in my
data
source. But in 2007, I want the document to open a table called
Members2007.
And so on.

Is that possible? If so, how do I do modify my document to do that? I'm
willing to use a macro if I can't do it any other way.

--
Rhino