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?