SQL Command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale - 19 Oct 2007 02:16 GMT

I have Microsoft Word 2002 and am a novice mailmerger. I successfully
created about a 200 name/address label list. When creating a second list I
could not get at the end of the process a Word doc with the labels on it. I
get the following dialog box: "Opening this document will run the following
SQL command: SELECT *FROM 'Office Address List' ORDER BY 'Last Name" ASC.
Data from your database will be placed in the document. Do you want to
continue?" But I only get a partial label list. What did I do wrong?

Signature

Dale

Reply to this Message

Graham Mayor - 19 Oct 2007 06:59 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 Microsoft Word 2002 and am a novice mailmerger. I successfully
> created about a 200 name/address label list. When creating a second
[quoted text clipped - 4 lines]
> placed in the document. Do you want to continue?" But I only get a
> partial label list. What did I do wrong?

Reply to this Message

Dale - 20 Oct 2007 19:40 GMT

I am unsure if you are asking a question or confirming what I had written.
If a question, the answer is yes. Whether I answer YES or NO, the Word doc
opens--but only with the partial list of labels, never the entire list I
typed into the database. How do I "unlink"? Why won't the mailmerge process
just export the entire database to the Word doc? Must I start over?

Signature

Dale

> 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 - 8 lines]
> > placed in the document. Do you want to continue?" But I only get a
> > partial label list. What did I do wrong?

Reply to this Message

Peter Jamieson - 20 Oct 2007 21:50 GMT

If you enable the Mail Merge Toolbar (View|Toolbars) and look at the
Mailmerge Recipients dialog, do you see all the records there? If so, maybe
you are previewing the label merge rather than completing the merge (i.e.
merging to a new document or merging to printer) If not, what is missing?
Records beyond a certain point? Records that conform to a certain pattern?
Anything you can see?

Peter Jamieson

>I am unsure if you are asking a question or confirming what I had written.
> If a question, the answer is yes. Whether I answer YES or NO, the Word
[quoted text clipped - 16 lines]
>> > placed in the document. Do you want to continue?" But I only get a
>> > partial label list. What did I do wrong?

Reply to this Message

Dale - 23 Oct 2007 00:50 GMT

Peter--When I open the dialog box, the Mailmerge recipients are all there.
The first time I data entered the names on this list (as opposed to the
previous list where I successfully created the labels), only one page (30
names) showed up in the Word document out of the 67 names on the list. I
repeated the mailmerge process and a different bunch of names showed up--no
pattern that I could recall. And then I have that annoying SQL Command box
popping up when I actually open the Word doc.
Any suggestions, as I have taken this list over from an invalid who had the
list in DOS on a 24 year old printer, and I am bumping against a mailing
deadline???

Signature

Dale

> If you enable the Mail Merge Toolbar (View|Toolbars) and look at the
> Mailmerge Recipients dialog, do you see all the records there? If so, maybe
[quoted text clipped - 25 lines]
> >> > placed in the document. Do you want to continue?" But I only get a
> >> > partial label list. What did I do wrong?

Reply to this Message

Peter Jamieson - 23 Oct 2007 08:31 GMT

Well, I suggest you either get rid of the SQL question using the reference
that Graham gave you, or just get used to it.

Are you actually "completing the merge"? A lot of people run into trouble
because what they do is "preview" the merge, then use File|Print to print
what they see. That isn't how Merge works. You have either to merge to the
printer or merge to a new document then print it. It generally becomes
clearer what is happening if you use e.g. View|Toolbars to enable the
Mailmerge toolbar, then use one of the buttons near the right hand end to do
the merge, rather than using the wizard.

Peter Jamieson

> Peter--When I open the dialog box, the Mailmerge recipients are all there.
> The first time I data entered the names on this list (as opposed to the
[quoted text clipped - 46 lines]
>> >> > placed in the document. Do you want to continue?" But I only get a
>> >> > partial label list. What did I do wrong?

Reply to this Message