Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kathleane
 
Posts: n/a
Default Print all records labels

I've several times carefully followed the directions for setting up a mail
merge with labels in MS Word vs 2003 (even though I know how to do this,
since I was having problems I started over from square one) and each time I
get the same result which is that the only records that print are 1-30. I
have it set up to print on a sheet of 30 labels. The only way I can print the
rest of the labels is to go to record 31 and print that page and so on.

I choose to print the entire document but get the same result each time -
only one page at a time will print.

Any ideas?
  #2   Report Post  
Michael
 
Posts: n/a
Default

Try this site by Graham Mayor:
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm. Good luck.


"Kathleane" wrote:

I've several times carefully followed the directions for setting up a mail
merge with labels in MS Word vs 2003 (even though I know how to do this,
since I was having problems I started over from square one) and each time I
get the same result which is that the only records that print are 1-30. I
have it set up to print on a sheet of 30 labels. The only way I can print the
rest of the labels is to go to record 31 and print that page and so on.

I choose to print the entire document but get the same result each time -
only one page at a time will print.

Any ideas?

  #3   Report Post  
Kathleane
 
Posts: n/a
Default

Thank you so much for your quick reply. All was looking good until I tried
to use the DDE option for my Excel list. I received the following error
message:
==================================
This error message can appear if you attempt to insert a database into a
Word document as an object or attach an Access data source to a Word
mail-merge main document.
This error message usually occurs if there is a problem communicating via
Dynamic Data Exchange (DDE).
Possible remedies are to reboot the system or attach the data source using
an alternative method (ODBC, DAO).
=================================
I am using an Excel list that I have successfully used many times in Word
2002.


"Michael" wrote:

Try this site by Graham Mayor:
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm. Good luck.


"Kathleane" wrote:

I've several times carefully followed the directions for setting up a mail
merge with labels in MS Word vs 2003 (even though I know how to do this,
since I was having problems I started over from square one) and each time I
get the same result which is that the only records that print are 1-30. I
have it set up to print on a sheet of 30 labels. The only way I can print the
rest of the labels is to go to record 31 and print that page and so on.

I choose to print the entire document but get the same result each time -
only one page at a time will print.

Any ideas?

  #4   Report Post  
Kathleane
 
Posts: n/a
Default

Forget my post saying I had problems with an error message. I clicked ok
thinking that all was lost but I just went back to the merge process and all
was well. Thank you very much.


"Michael" wrote:

Try this site by Graham Mayor:
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm. Good luck.


"Kathleane" wrote:

I've several times carefully followed the directions for setting up a mail
merge with labels in MS Word vs 2003 (even though I know how to do this,
since I was having problems I started over from square one) and each time I
get the same result which is that the only records that print are 1-30. I
have it set up to print on a sheet of 30 labels. The only way I can print the
rest of the labels is to go to record 31 and print that page and so on.

I choose to print the entire document but get the same result each time -
only one page at a time will print.

Any ideas?

  #5   Report Post  
Kathleane
 
Posts: n/a
Default

Why couldn't Microsoft have given the instructions that actually worked?


"Kathleane" wrote:

Thank you so much for your quick reply. All was looking good until I tried
to use the DDE option for my Excel list. I received the following error
message:
==================================
This error message can appear if you attempt to insert a database into a
Word document as an object or attach an Access data source to a Word
mail-merge main document.
This error message usually occurs if there is a problem communicating via
Dynamic Data Exchange (DDE).
Possible remedies are to reboot the system or attach the data source using
an alternative method (ODBC, DAO).
=================================
I am using an Excel list that I have successfully used many times in Word
2002.


"Michael" wrote:

Try this site by Graham Mayor:
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm. Good luck.


"Kathleane" wrote:

I've several times carefully followed the directions for setting up a mail
merge with labels in MS Word vs 2003 (even though I know how to do this,
since I was having problems I started over from square one) and each time I
get the same result which is that the only records that print are 1-30. I
have it set up to print on a sheet of 30 labels. The only way I can print the
rest of the labels is to go to record 31 and print that page and so on.

I choose to print the entire document but get the same result each time -
only one page at a time will print.

Any ideas?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print labels from excel with title and number Ray Excel Discussion (Misc queries) 1 January 22nd 05 11:47 PM
How do I print row labels on alternating pages of an Excel workshe Beckygnc Excel Discussion (Misc queries) 0 January 18th 05 02:57 PM
can I print labels using data from an excell spreadsheet Cesspool lady Excel Discussion (Misc queries) 2 January 18th 05 06:53 AM
Can I transfer data from and excell spreadsheet to print labels u. Cesspool lady Excel Discussion (Misc queries) 2 January 17th 05 06:39 PM
How do I print onto Labels in Excel ÎË®ÑÞ Setting up and Configuration of Excel 1 December 9th 04 04:36 AM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"