Hi there,
I have a 20Rx10C table and columns are headings like Name Sirname phone
number etc.
I have given a task to print all that data on stickers(10,5x4cm) in a format
like

Name Sirname
Phone number
Adress
Note

I've heard there is a way to do this with excel automatically. Any idea to
achive this?
Thank you for you help
Mns

hi
basicly all excel does is send the data. it has some size options but limited.
speaking for 2003 back, not sure about 2007.
set your sticker printer as default then on the menu bar.....
filepage setupoptions button.
this should display your default printer options. check and see if your
sticker printer doesn't already have the desired size. if not...
you may have to play with the row highth and font size to make it fit the
lable(sticker?). yeah i know. trial and error(yuk). but i did have to do that
once back in xl2000 days.

regards
FSt1
"MnS" wrote:

Hi there,
I have a 20Rx10C table and columns are headings like Name Sirname phone
number etc.
I have given a task to print all that data on stickers(10,5x4cm) in a format
like

Name Sirname
Phone number
Adress
Note

I've heard there is a way to do this with excel automatically. Any idea to
achive this?
Thank you for you help
Mns

Hi FSt1,
my table is like
A B C D
1| Name Sirname EditDate Payment ...
2| Jhon Smith 12.06.2008 20.000$

which I'd like to be printed like below

Jhon Smit
12.06.2008
20.000$

And is therea label printing printer:S cant I do it with a normal one like
HP deskjet?




"FSt1" wrote:

hi
basicly all excel does is send the data. it has some size options but limited.
speaking for 2003 back, not sure about 2007.
set your sticker printer as default then on the menu bar.....
filepage setupoptions button.
this should display your default printer options. check and see if your
sticker printer doesn't already have the desired size. if not...
you may have to play with the row highth and font size to make it fit the
lable(sticker?). yeah i know. trial and error(yuk). but i did have to do that
once back in xl2000 days.

regards
FSt1
"MnS" wrote:

Hi there,
I have a 20Rx10C table and columns are headings like Name Sirname phone
number etc.
I have given a task to print all that data on stickers(10,5x4cm) in a format
like

Name Sirname
Phone number
Adress
Note

I've heard there is a way to do this with excel automatically. Any idea to
achive this?
Thank you for you help
Mns

If you have MSWord, you can use excel to hold the data and MSWord to print the
labels.

(saved from a previous post)

You may find that using excel for your data and MSWord for your invoice looks
prettier.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

And just in case you have text that needs to be formatted (percentages, for
example):

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

MnS wrote:

Hi there,
I have a 20Rx10C table and columns are headings like Name Sirname phone
number etc.
I have given a task to print all that data on stickers(10,5x4cm) in a format
like

Name Sirname
Phone number
Adress
Note

I've heard there is a way to do this with excel automatically. Any idea to
achive this?
Thank you for you help
Mns

--

Dave Peterson

hi
dave may have a much better suggestion than i had.
i illogicaly assumed that you had access to a label printer and that your
data was layed out in the printable format. I have used xl to print lables
but not in a while.

regards
FSt1

"mns" wrote:

Hi FSt1,
my table is like
A B C D
1| Name Sirname EditDate Payment ...
2| Jhon Smith 12.06.2008 20.000$

which I'd like to be printed like below

Jhon Smit
12.06.2008
20.000$

And is therea label printing printer:S cant I do it with a normal one like
HP deskjet?




"FSt1" wrote:

hi
basicly all excel does is send the data. it has some size options but limited.
speaking for 2003 back, not sure about 2007.
set your sticker printer as default then on the menu bar.....
filepage setupoptions button.
this should display your default printer options. check and see if your
sticker printer doesn't already have the desired size. if not...
you may have to play with the row highth and font size to make it fit the
lable(sticker?). yeah i know. trial and error(yuk). but i did have to do that
once back in xl2000 days.

regards
FSt1
"MnS" wrote:

Hi there,
I have a 20Rx10C table and columns are headings like Name Sirname phone
number etc.
I have given a task to print all that data on stickers(10,5x4cm) in a format
like

Name Sirname
Phone number
Adress
Note

I've heard there is a way to do this with excel automatically. Any idea to
achive this?
Thank you for you help
Mns