.
Welcome at TheRoyalStore.com!
.
.
.
.
Need help? Call 203-644-1270/1271
You are here:  HomeFAQHow to use Iclinknprint

How to use Iclinknprint


LEARN HOW TO USE ICLICKNPRINT


Iclicknprint
Click the logo to go to Iclicknprint

How to Merge Mailing Labels Using an Excel File

Here is a short demo for entering data by hand in mailing labels.

http://www.iclicknprint.com/demo-videos/custom-mailing-labels/ 

To merge data from Excel, follow these instructions:

Prepare your Excel File as follows: enter First name, Last name in column 1, Address 1 (Number and Street) in column 2, Address 2 (State and Zip code) in column 3. Use Address 4 in column 4 (if really needed). Each of these rows will become one line of text in your mailing labels. If you have more than 4 columns, the Excel file may give an error message when you merge, since your label cannot take more than four lines of text or you may have to edit text and reduce the font size to fit all the rows in a label.
Save the Excel file give it a memorable name, so you can easily find when browsing files.
See Example:

Excel File Merge Address Labels Example

The text box is preset in most labels.
IMPORTANT: Format the first text box correctly to prevent having to edit each label individually, after the merge. This means the size of the textbox on the label should be right and the cursor should be in the first box. If you are merging 90 addresses or multiple of 90, you can customize the first label with the first address in your file using the font, font size and color of choice. All the other labels will keep these customizations when data is merged.
To make changes in one label, Click to edit individual cards and use close preview.
Please note that if you change anything in the main label, without a click on the Click to edit individual cards (top right), the first address will populate all the labels and you will have to perform another mail merge.

MERGE STEPS:

1.Start by removing the default text in the main textbox. If necessary, enlarge and position the textbox properly on the label. The cursor needs to be in the first label textbox.

2. Click Merge Data (left menu) and upload your Excel or CSV file. The text of each column in your Excel will go on each row of the label. ie. First & Last Name from Column 1 go on Row 1; Street from Column 2 goes on Row 2; City, Zip Code from Column 3 go on Row 3. Choose a good font. We recommend Gara 28 that fits well most labels. Use Center or Align left.
Click Start mail merge - Select File and upload the file.
Check the data and if it looks OK, click NEXT if not, click Back and redo and reupload the file with Merge Data.
The Merge Data screen will require you to add each address rows 1,2,3,4, from the left panel with your Excel Data (Select Column) to the right blank panel (Selected Column).
Each column added from left to right will appear as Column 1, 2, 3, 4, in the Selected Column. The columns will be positioned as rows of text one under the other in the labels.
Click NEXT. Choose the orientation of the page to print: Portrait is standard for Mailing Labels and Business cards. A PDF file will be prepared for you to download. It may take anywhere from a few seconds to a minute, depending on the amount of data merged.

When merge is ready, the first label will show the first address on it. To see all pages, click Preview (right top eye-icon). REMEMBER to check the box Click to edit individual cards (top right) if you need to edit a label or reposition a text box inside a label. If you are in preview, click the Close Preview button to make changes in each textbox.
Save the file as often as you can.
To edit an individual label or reposition a text box inside a label, check the box Click to edit individual cards (top right). After changes were made, save the file.

3. Click Print (top right, main menu). Choose the Print Orientation. Click NEXT. To see all pages, click Preview (right top eye-icon). To Print, Click the Print icon (top right, main menu). Choose the Print Orientation (Portrait is standard for mailing labels and most business cards). Click Next. The PDF file creation time depends on the number of your project pages. When the PDF is created, a screen with Download PDF Now link will appear.
A Download PDF page will open in your browser. Click the Download button at the top right side of the screen. Save As or Open (see what the file looks like) then File - Save As and save the file with a memorable name on your desktop. Go to your Desktop, open the file and print it on a blank test page, using the correct page layout (Portrait for mailing labels).

In printer settings, use Actual Size setting. Never use the Fit to Page setting, or lell than 100% Fit as it will distort the positioning of the text on the labels.

If the page does not open automatically (this depends on the settings of your browser) look in the Downloads folder for a .pdf file named drawing that looks similar to this: drawing 123456789.pdf.

In some browsers, the file will open directly for download. In others, it will appear at the bottom of the screen (IE). In Mozilla Firefox, it will appear under the blue arrow, top menu in downloads. Look for it.

Please do not print the WebPDF file which may be the case with Mac computers that do not save PDF Files. Web PDF reformats the file for a Fit to Page which distorts the positioning of the text on the page. Call or email us with the project name and login info and we will send you the correct pdf files by email.

DO NOT USE FIT TO PAGE in your printer settings!

Recommended: Print a test page on a blank sheet of paper, first. Check text alignment against the label sheet. If alignment is correct, start printing your labels. If incorrect, go back to My Saved Projects and try to correct the issue or contact us.

What you see in the Preview should be what you print. Sometimes, if the text goes too far right, on the third column of labels, the printer may not print the last one or two characters (printer margins).
Make sure you do not enter text too close to the far right margin of the labels in the third label column.

With Mac computers, sometimes the last digit of the zip code disappears in certain browsers. We recommend adding a dash or an underscore after the last digit of the zip code.

Use the latest versions of Chrome or Mozilla Firefox. They work best with Iclicknprint. Safari and IE may cause some issues for both Mac and PC.

Open and print it using the correct page layout (Portrait for mailing labels).
In printer settings, use Actual Size setting, do not use Fit to Page setting, as it will distort the positioning of the text on the labels.

If the page does not open automatically (this depends on how your settings in your browser were made) look in Downloads for a pdf file named drawing which has a set of numbers before the .pdf file extension, similar to drawing 123456789.pdf.
In some browsers, the file will open directly to be downloaded. In others, the file will show at the bottom of the screen or in Firefox, it will appear under the blue arrow, top menu in downloads. Just look for it.

Please do not print the WebPDF which may be the case with Mac computers that do not save PDF Files. Web PDF reformats the file for a Fit to Page which distorts the positioning of the text on the page.

DO NOT USE FIT TO PAGE in your printer settings!

Recommended: Print a test page on a blank sheet of paper, first. Check text alignment against the label sheet. If alignment is correct, start printing your labels. If incorrect, go back to My Saved Projects and try to correct the issue or contact us.
What you see in the Preview should be what you print. Sometimes, if the text goes too far right, on the third column of labels, the printer may not print the last one or two characters. Make sure you do not enter text too close to the far right margin of the labels in the third column.
With Mac computers, sometimes the last digit of the zip code disappears in certain browsers. We recommend adding a dash or an underscore after the last digit of the zip code.

Use the latest versions of Chrome or Mozilla Firefox. They work best with Iclicknprint.
Safari and IE may cause some issues for both Mac and PC.

MERGE DATA FOR BUSINESS CARDS:

Business cards have pre-made templates that can be used and customized - available in the left side menu – TEMPLATES tab.
1. Prepare the Excel file to have a column with data for each text box.

2. Click the first textbox, click Merge Data - Start Mail Merge, click Next. Do this for each textbox you need to merge data with. Otherwise, all the data from the columns with gather in the fist textbox where the cursor is.
ie. After merging Column 1 data in textbox 1, go to textbox 2 click Merge Data - Start Mail Merge and Next. Select column, Click arrow and Next. Continue with the same process until you finish bringing each column in each textbox.

3. Print. When the merge has been successfully completed and the cards look as wanted, click the Print icon top menu right. A PDF file for download will be prepared for you. Choose the orientation Portrait for Business cards unless you want them printed on the landscape page

WE RECOMMEND: Make all the changes in the Excel/CSV file, first. Any changes directly on the card/label without checking the "Click to edit individual cards" will copy the first card data all over the card pages. If this happens, start the merge process again. Close Preview allows you to customize individual cards or labels.

Customize Text Boxes:
Double click on the text box, delete the existing default text and add your own. You can enlarge the text box to your needs by dragging one of the box corners. Move your text box and place it anywhere on your project. Select the text in the box to change the font, size and color. Delete a text box by selecting it and click "Delete" button located in the main menu.

Upload Image:
Click "Add Image" icon in the top main menu, browse image file (files accepted are .jpeg and .png, maximum size 5 MB.) Use Properties to edit image proportions and orientation, etc.

Shapes and Lines:
Available in the left menu. Click on the desired shape once. It will appear on your project. Delete, move or resize a shape the same way as a text box or image. Color a shape - select the shape, Use Shape Fill and use the color palette. Check No Fill if you wish it transparent. Use Border size to thicken the border and Border Color to color it. Check No Border is necessary.

Clip Art:
Click the Clip Art tab, left menu. Choose clip art from categories – click once and it will appear on your project. Delete, move or resize clip art the same way as a text box, image or shape.

 

WORD file Mail Merge


In your Word Mailings – Start Mail Merge, choose Avery Mailing label no 5160. Measure the design on the Geographics Mailing labels. Most users leave a left margin of 0.75 to 1 inch on each row of labels, to avoid printing over the design.

Alternately, for manual input use a TheRoyalStore Word Template – search by item number in the blue search box. Click on the download template link and save it in your computer, under a memorable name. Open the template and start copying and pasting your labels from the original address Word file (use CTRL+A to highlight the text, CTRL+C to copy it, click text box in template and CTRL+V to paste it).

or

Copy and paste each address from your Word file into the Iclicknprint label. Go to Iclicknprint and search for the item# in the top search box.
Login and set up your default text box in the main label and follow the process highlighted above.

To transfer addresses from a Word to an Excel file, you can convert Word to Excel or CSV.
To convert your Word file to CSV use https://convertio.co/doc-csv/.
Then copy and paste the data in Excel. The addresses will be copied one under the other, with empty cells in between.
To get rid of the empty cells, insert a new column in front of the name and address. Number all cells (1, 2 then drag down the numbers to the end of the last address).

Select all data. Sort data from A to Z by Column B (which will contain all names and addresses).
After sort, in column A, delete the numbers in front of the empty the cells. Select all data. Now, you have eliminated all the empty cells.
Sort data by Column A (numbers) from A to Z. This will get the correct names and corresponding addresses, in order.
Copy and paste the data directly from the name and address (usually maximum 4, listed one under the other).

Paste Special - Check the Transpose box. It will align the address rows from left to right, the way it is required for merge in Iclicknprint. Keep on doing this with each address, until the end.
Save the file. This is labor intensive but once done, you can reuse it, year after year and add to it. For another way to convert your Word file to CSV (Comma Separated Values) where text elements that have to be spaced have values enclosed in quotes, such as "Giorgio Armani", follow these steps:
Use Table Tools - Layout tab - Convert to Text. Check the comma box as an option to separate variables.
Use CTRL+H  or find/replace to insert quotes, as needed.
Choose Save As and save the file with the extension .csv.
It would be easier to copy the table to Excel and then save it directly from Excel in .csv format. You still need to deal with the quote issue for any text containing spaces.

How to do Mail Merge in Works using TheRoyalStore Mailing Labels

TO CONVERT FILES FROM WORKS, odt format to WORD or EXCEL:
Try to copy and paste the addresses from Works in Excel and see what happens. Sometimes they copy all right.
Follow the Excel address arrangement required for Iclicknprint.com, see image provided above.

Or, use a converter from Works to Excel and follow the steps highlighted.

You may do a Google search for the keyword “converter from Works to Excel” and pick up the best resource.

In order to find the item you need to customize in Iclicknprint, enter the item number in the top right search box.
Open it. Set up the text box in the main label and follow the steps mentioned above.
After completing the customization of your selected product, click on the "Import Data" tab located on the left side of the page which will allow you to merge information from a data file (such as names, addresses, etc.). Please make any customization needed to your project before starting the merge process.

How to merge data from an Excel or CSV file:

  1. Select the text box you wish to merge data in and click the MERGE DATA tab, left menu.
    2. Click "Browse Files" and upload the Excel or CSV file that contains the data you want to merge.
    3. Make sure there is an active cursor in the text box that you will be merging data in. Click the Start Mail Merge button. Select the columns you wish to merge from Select Column – with a click  on the middle arrow. The Selected Columns will show in the right panel as Column 1,2,3 etc. Click Next. Your data will be merged and a PDF file will be prepared for you to download and print.

When customizing business cards and not merging any data you can simply enter your data by adding textboxes on the card or use one of the templates available. If you need to print additional pages of business cards, click the New Page button above the business cards preview.

How to Print your Project

  • 1. Once your customization is completed click the print icon in the main menu. You will be prompted to save your project. Select the orientation of the sheet for printing purposes. A high resolution PDF document will be generated for printing.
  • 2. Download your PDF file in your computer and then print it from there. The correct printing is achieved by downloading the pdf document to your computer and then printing it.

Useful tools:

Click here to download a sample excel file containing merge data format for mailing labels.

 

How to Get Data from Word file to Excel File:

Click here to download the PDF File with instructions.

 

Printing settings:

Settings may vary from printer to printer, and you will have to manually make the desired adjustments. We recommend printing some test pages before printing on the actual Geographics stationery. What can you adjust in your local printer settings?

Page orientation - Depending on the project, you have to select either portrait or landscape orientation.
Color - Print Black & White or Color.
Print borderless (Limitations apply to different printers). All Photo Printers have the capability to print borderless.
Paper size
Paper quality

If you have issues using Iclicknprint, please contact customer service through online chat or direct phones 203-644-1270 and 203-644-1271 or email support@iclicknprint.com and we will get in touch as soon as we can, Thanks for using our products!


FREE Templates Clip Art & Wording