How to: Send Labels to a File in Interlink Circulation

The following 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:

  1. Select Configure Printers from the File menu.
  2. Select the tab titled Labels.
  3. Select the circle next to Send Labels to File.
  4. Click the Browse button.
  5. Specify a location and name to save your .csv file. I suggest the desktop so you can find the file easier. (e.g. desktop:\paperproductlabels.csv).
  6. Click the Save button.
  7. Select CSV from the drop down labeled File Format.
  8. Click the OK button to save your changes.
  9. This creates a blank file on your desktop. Each issue, process the labels as listed below. When you finish, the data for the labels will be in the file on your desktop. Email this file to: circlabels@sentinelnews.com

 

To create the .csv file for a given mailing:

  1. Ensure you have already closed the issue you wish to create a .csv label file for.
  2. Click the Print Reports button from the main screen.
  3. Select either Periodical Mailing Labels or Standard Mailing Labels depending on the nature of your publication.
  4. Click the Print button. Make any adjustments to how the labels should appear in the file. The default settings are appropriate for most situations.
  5. Click the Continue button.
  6. When the progress dialog disappears your .csv file will be complete.

 

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.