| TO
PRINT LABELS: |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
| Use
the dropdown select to pick which labels you want to print above town #. |
|
|
| Click
"EDIT"-->"GOTO"-->"SPECIAL"-->"VISIBLE
CELLS ONLY" |
|
|
| Click
the COPY BUTTON---NOT "edit" "copy, or "right click"
"copy"…. Only the button will work. |
|
|
| Select the sheet "PRINT LABELS" and
click the "PASTE BUTTON"…. Same as copy… not under EDIT or right
click… only BUTTON will work. |
| Save. |
|
|
| Open
the page, labels.doc, make SURE your cursor is in the center position of the
first label cell, |
|
|
| and
then minimize the page. Open the
printLabels sheet from the disco workbook. |
|
|
| With
your printLabels sheet showing, select
"TOOLS"--->"Macros"--->"Macros">
select PrintResaleLabels |
|
|
| and click RUN. |
|
|
| |
|
|
| Once
your labels print, close labels.doc WITHOUT saving the changes. |
|
|
| Also
close your printLabel sheet WITHOUT resaving it. |
|
|
| The
page will be cleared and reset on next use.
Saving here will cause it to be saved as a document file, |
|
|
| and leave it useless! |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
"Save and
Reset" clears the contents of the Zip Sort page, once they reach total
300. |
|
| |
Contents
will be copied to a new sheet, which will need to be renamed with the date it
was reset, and saved manually. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|