ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Labels - Almost there.. But.. How to get multiple on a pa (https://www.excelbanter.com/excel-discussion-misc-queries/262976-printing-labels-almost-there-but-how-get-multiple-pa.html)

KGlennC

Printing Labels - Almost there.. But.. How to get multiple on a pa
 
I can successfully merge Excel and Word (using *.csv as data source)
[Excel2007; Word2007]. I selected Avery lavel 5163. Addresses are good.
Unfortunately, when I print, only one label prints on a page, not the 10 that
supposed to print per page.

I see one (1) <<address block on the document layout plus nine (9) <<next
record.

I tried manually plus using the wizard, but no luck.

I've done this before, but with Word2003, 4 years ago. I'm perplexed. What
am I missing?

Thanks in advance.

Dave Peterson

Printing Labels - Almost there.. But.. How to get multiple on a pa
 
If you don't get an answer in this Excel newsgroup, you may want to ask your
question in a forum dedicated to MSWord.

KGlennC wrote:

I can successfully merge Excel and Word (using *.csv as data source)
[Excel2007; Word2007]. I selected Avery lavel 5163. Addresses are good.
Unfortunately, when I print, only one label prints on a page, not the 10 that
supposed to print per page.

I see one (1) <<address block on the document layout plus nine (9) <<next
record.

I tried manually plus using the wizard, but no luck.

I've done this before, but with Word2003, 4 years ago. I'm perplexed. What
am I missing?

Thanks in advance.


--

Dave Peterson

KGlennC

Printing Labels - Almost there.. But.. How to get multiple on
 
Good point.. didn't think of that.

"Dave Peterson" wrote:

If you don't get an answer in this Excel newsgroup, you may want to ask your
question in a forum dedicated to MSWord.

KGlennC wrote:

I can successfully merge Excel and Word (using *.csv as data source)
[Excel2007; Word2007]. I selected Avery lavel 5163. Addresses are good.
Unfortunately, when I print, only one label prints on a page, not the 10 that
supposed to print per page.

I see one (1) <<address block on the document layout plus nine (9) <<next
record.

I tried manually plus using the wizard, but no luck.

I've done this before, but with Word2003, 4 years ago. I'm perplexed. What
am I missing?

Thanks in advance.


--

Dave Peterson
.



All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com