Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Printing labels on a dot matrix via Excel

I am trying to print tractor-fed labels on a Epson printer. Each 'page' is 4
inches long, and contains 2 labels with 12 lines on each label (i.e. 6LPI).

When I try to do this, the page of detail looks like it fills the page in
print preview, but when I end up printing it, its prints a bit smaller than
intended and not printing on the labels in the correct area.

I have set all margins to zero, and set the row height to 12.

Is there any resources anyone can direct me to in order to solve this?

Thank you

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Printing labels on a dot matrix via Excel

Printing labels from Excel is strictly trial and error.

Best method is to use Word's mailmerge with Excel as the data source.

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 14:14:02 -0700, sdrais
wrote:

I am trying to print tractor-fed labels on a Epson printer. Each 'page' is 4
inches long, and contains 2 labels with 12 lines on each label (i.e. 6LPI).

When I try to do this, the page of detail looks like it fills the page in
print preview, but when I end up printing it, its prints a bit smaller than
intended and not printing on the labels in the correct area.

I have set all margins to zero, and set the row height to 12.

Is there any resources anyone can direct me to in order to solve this?

Thank you


Gord Dibben MS Excel MVP
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
Contact List in Excel - Printing Labels in Word Laura Excel Discussion (Misc queries) 4 March 22nd 06 06:50 PM
Printing Labels from Excel Alec H Excel Discussion (Misc queries) 0 March 1st 06 09:45 AM
Creating Address Labels in Excel Mandy Banks Excel Discussion (Misc queries) 4 December 30th 05 07:20 PM
Problems printing templates in Excel XP BPS Excel Discussion (Misc queries) 1 June 16th 05 11:18 PM
Convert Word labels to Excel spreadsheet Lisa Excel Discussion (Misc queries) 2 January 18th 05 10:36 PM


All times are GMT +1. The time now is 12:19 AM.

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

About Us

"It's about Microsoft Excel"