View Single Post
  #1   Report Post  
Los
 
Posts: n/a
Default Excel 2003 and Labels (NOT Address Labels)

Okay, this is insanse.

Have a spreadsheet where I input data into one cell, a calculation based on
that data is run via vb macro, and then a single column of data with 80 rows
is generated.

CellA1
CellA2
....
CellA80


I need two things:

One: I need all 80 results printed onto Avery 5267 format sheets of Labels.
I will need four copies of each label, and I need the sheet to print EXACTLY
like this (not allowed to vary on this):

CellA1 CellA1 CellA1 CellA1
CellA2 CellA2 CellA2 CellA2
etc ...

Two: I would like to NOT use Word.


I've tried formatting the cells in the worksheet to have the pixels points
match the size of the avery labels. I saw that 72 pixcels is supposed to
equal 1 inch.

I have actually taken a physical rule and MEASURED the required
indentations, cell sizes, EVERYTHING. I then calculated what should be .25",
1.5", etc. Still the page prints horribly incorrectly.

Why is it so hard to do this without Mail Merge?