Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Regal bath
 
Posts: n/a
Default i want to print labels from excel without all hassle or mail merge

I have a number of files in excel and i want to print the first 3 rows onto
lables but do i have to go to the hassle of using word
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default i want to print labels from excel without all hassle or mail merge

I t hink you'll find that the hassle of using Word is considerably less than
the hassle of laying out labels in Excel. At least you can select the label
size you wish to user is Word and it will automatically produce a table with
the label layout necessary for that particular label. You can then use mail
merge to retrieve the first 3 rows of data from your Excel data source.

Just a suggestion...
--
Kevin Backmann


"Regal bath" wrote:

I have a number of files in excel and i want to print the first 3 rows onto
lables but do i have to go to the hassle of using word

  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1
 
Posts: n/a
Default i want to print labels from excel without all hassle or mail merge

hi,
no. lables are just another print media. excel will consider each lable as 1
"page" so you may have to play with the margins to make sure that all your
data gets printed on 1 lable and doesn't bleed onto 2 lables.

regards

FSt1

"Regal bath" wrote:

I have a number of files in excel and i want to print the first 3 rows onto
lables but do i have to go to the hassle of using word

  #4   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default i want to print labels from excel without all hassle or mail merge

and with each printer and with your fonts, etc. In fact you may not
be able to line them up. There are some Excel templates to are
fixed. BTW, make sure that under File, Page Setup, Page
you do not have any scaling s/b 100% and pages wide and tall
should be empty.

Suggest you reconsider using MS Mail as that is what Microsoft
provides for. For specific directions see
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"FSt1" wrote in message ...
hi,
no. lables are just another print media. excel will consider each lable as 1
"page" so you may have to play with the margins to make sure that all your
data gets printed on 1 lable and doesn't bleed onto 2 lables.

regards

FSt1

"Regal bath" wrote:

I have a number of files in excel and i want to print the first 3 rows onto
lables but do i have to go to the hassle of using word



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
nine digit zip code won't print in mail merge Durham Excel Discussion (Misc queries) 11 July 1st 08 12:34 PM
Mail Merge in Excel DPurplRose Excel Worksheet Functions 1 February 21st 06 08:25 PM
How do I mail merge from different excel worksheets? Pure Excel Discussion (Misc queries) 3 February 21st 06 03:08 PM
Field missing on completed mail merge Excel - Word once merged Baffled PA Excel Discussion (Misc queries) 0 February 15th 06 01:21 PM
how do I use mail merge in excel for word documents Lisa J Duffy Excel Discussion (Misc queries) 1 August 4th 05 01:40 PM


All times are GMT +1. The time now is 08:28 AM.

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

About Us

"It's about Microsoft Excel"