Excel - Word 2003

[vern-dot2]

Have a classmate listing in Excel 2003 document. Have created mailing
labels (2 pages, 30 labels per 8 1/2 x 11" page) in Word 2003 and gave
it its own name. First time it printed fine. Need to print labels
for another mailing and only page 1 comes up. Have tried Microsoft
newsgroups with no success. When opening my Word label doc. I get
this message: Opening this document will run the following SQL
command: SELECT*FROM 'SHEET 1$' Data from your database will be
placed in your document. YES NO No matter whether I click Yes or
No, I get only page 1 and it will print ONLY PAGE 1. Using Office
2003 Professional with Windows XP professional. Help please!!

 

[John McGhie]

To have a good chance of success with Microsoft Groups you need to ensure
that you ask your question in the correct group.

You asked in a Macintosh Word group: we do not have Excel 2003 or Word 2003
on the Macintosh.

I have cross-posted your message to the correct group:
microsoft.public.word.mailmerge.fields

Cheers

--

John McGhie, Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs

+61 4 1209 1410, <mailto:[email protected]> mailto:[email protected]

 

[Doug Robbins - Word MVP]

For the SQL issue, see the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

That however will be having nothing to do with your only getting one sheet
of labels when you print. That is cause by your only printing a preview of
the result of the merge rather than actually executing the merge to the
printer or to a new document and then printing that document.

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP