SQL Command

[Dale]

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?

 

[Graham Mayor]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Dale]

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?

 

[Peter Jamieson]

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

 

[Dale]

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???

 

[Peter Jamieson]

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