How to: Send Labels to a File in Interlink Circulation
information describes the steps required to create a text file containing the
information used to produce mailing labels by Interlink Circulation. Typically
this is required when your paper is directly addressed via an inkjet system at
the location where your paper is printed.
The way Interlink Circulation handles this is by creating a single .csv (Comma Separated Values) file that can be sent to the location with the direct addressing system. That system will then import the .csv file and use it to address your paper.
To configure Interlink Circulation to produce a .csv file:
To create the .csv file for a given mailing:
After you save the labels to a file but before you email to Diana, open the .csv file. Add a column at the beginning. Type in 1 in the 1st row, 2 in the 2nd row, 3 in the 3rd row and then use the Auto-Fill to fill in the numbers for how ever many rows there are.
Then, use the Data/Sort to flip the list. Sort by the columns of numbers you just added and change from Ascending to Descending. Make sure you have all the data highlighted before this step. If you have only part of your data highlighted you could get mixed up names and addresses.
Once the list is flipped, delete the column A that you added, leaving only the original data. Resave and email.
If you are unfamiliar with these Excel functions, email me your labels and call me and we'll do it together.