Basic Mail Merge Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhino - 17 Jun 2006 14:39 GMT

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

Reply to this Message

Graham Mayor - 17 Jun 2006 15:07 GMT

You receive the "Opening this will run the following SQL command" message
when you open a Word mail merge main document that is linked to a data
source - http://support.microsoft.com/?kbid=825765

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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.
[quoted text clipped - 33 lines]
> 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.

Reply to this Message

Rhino - 17 Jun 2006 16:18 GMT

I don't really object to that message; I was really just leading up to the
second issue: how do I change which data source gets opened? Somewhere, my
document must be storing an association with that data source and I assume
there is some way to change that association to a different data source.

--
Rhino

> You receive the "Opening this will run the following SQL command" message
> when you open a Word mail merge main document that is linked to a data
[quoted text clipped - 37 lines]
>> 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.

Reply to this Message

Suzanne S. Barnhill - 17 Jun 2006 15:25 GMT

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.

Signature

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.

> 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
[quoted text clipped - 36 lines]
> --
> Rhino

Reply to this Message

Rhino - 17 Jun 2006 16:22 GMT

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

> 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
[quoted text clipped - 58 lines]
>> --
>> Rhino

Reply to this Message

Suzanne S. Barnhill - 18 Jun 2006 01:03 GMT

If you're pretty sure the user will be you, then here's what I find helpful.
Put your instructions to yourself in the Comments field of File |
Properties. If you make a habit of doing this, you'll remember to look
there.

This is actually an idea that I ought to use more often; at present I use it
only to indicate "#10" or "Label" for a client who has a tendency to give me
letters to type and then not get around to sending them till days later.
Since I don't usually print the envelope or label until I print the final
copy of the letter (by which time I've given him back the draft on which he
had written the #10 or Label notation), this helps me remember which to
print.

Signature

> Okay, I can live with those solutions.
>
[quoted text clipped - 69 lines]
> >> --
> >> Rhino

Reply to this Message