Click the above logo to go to ICLICKNPRINT® 2018
We are delighted to let you know that we have released ICLICKNPRINT® 2018, a new & improved beta version, available at www.iclicknprint.net.
This HTML version will replace the Adobe Flash Iclicknprint.com by May 1, 2018.
Iclicknprint 2018 requires new registration. Use the same email and password you are using now in iclicknprint.com.
We invite all Iclicknprint.com users to save their projects in their computers or external memory devices.
By May 1, 2018, the Iclicknprint Adobe Flash version will be phased out.
Your saved projects will no longer be accessible.
Save your projects, give them memorable names so you can continue to use them in the future.
Create new projects using our new and improved free customization tool that can help you easily
personalize Geographics and Royal Brites products.
Please check out the Demo page to visualize our silent demos.
Mailing Labels - How to Merge Data from Excel
To merge data from Excel, follow these steps:
Prepare your Excel File data by entering:
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 the 4 rows will become one line of text in your mailing labels.
Save the Excel file, under a memorable name, in a memorable folder.
Place all your data in the first sheet Sheet 1 of the Excel file.
Remove Headers that are not the actual data you want imported.
See the example below:
Add a text box in the first label. Resize and customize it with 4 maximum lines of text.
IMPORTANT: Format the first text box on the label sheet, correctly in order to save your effort of having to edit each label individually, after the merge. Resize of the textbox on the label so it stays within the image. Enter text. Customize the first label with the first address in your file using font, font size and color of choice. All the other labels will keep the same format after merge. Use the longest address.
To make changes in one label - In Preview | New Page, next to Edit, check the radio button Create Separate Cards/Labels. After Merge was finished, Create separate cards/labels will be the default.
A check on Synchronize content in all cards/labels, will make the address you have on populate all the other labels.
MERGE STEPS for Address Mailing Labels:
1. Add Text Box T on the main label or card. For mailing labels, one textbox is sufficient. For cards you need to add multiple text boxes and replace the default text with your text.
Enlarge and position the textbox properly on the label. The cursor needs to be in the textbox of the first label.
In the last tab of the Editor called MERGE, Click Start Data Merge and upload your Excel or CSV file - maximum allowed size is 1MB. 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 that will fit well in most labels. Use Center or Align left.
Check your data and if it looks OK, click NEXT if not, click Back. Rework and reupload the file with Merge.
Drag and drop data from the left columns of your file to the right columns of your text box(es) in the order intended.
A PDF file will be prepared for you to download. It may take a while, depending on the amount of data merged.
To see each merged page, click Preview. Make any changes needed. Save the file.
To edit an individual label or reposition a text box inside a label, check the radio button
Create separate cards/labels.
3. SAVE & PRINT
Save the file after you make major changes. Click Print (top right, main menu).
This action will convert the file to PDF and will make it ready for download.
Preview each page, return and make any needed edits before hitting Print.
The PDF file creation time depends on the number of your project pages and the number of images you have on page. We suggest that you upload images at the end.
Download PDF File will open a screen that gives two choices: Open File (will open it in the browser)
and Save file.
Please save the file in your computer. Do not print it directly from the browser.
After saving it, open the file from your computer. Print will open Print settings where you need to make choices.
Make sure ACTUAL SIZE is checked and choose paper size and orientation from properties.
Choosing printing settings other than Actual Size or printing from your browser will distort the positioning of the text on your labels.
Print a blank test page, using the correct page layout (Portrait for Mailing Labels).
Check the 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. there will be a feedback screen related to Print success. NO will give you further instructions. Yes, will send you to the Home page.
What you see in the Preview should be exactly what you print. If your text goes too far right, into the printer margins (third labels column), your printer may cut off the last one or two characters.
Make sure you do not enter text too close to the printer margin in the third column.
With Mac computers, in the Adobe Flash, in certauin browsers, the last digit of the zip code sometimes disappeared. The fix was to add a dash or an underscore after the last digit of the zip code.
MAIL MERGE USING A WORD FILE
Iclicknprint Merge does not work with Word files. Use MS Office Word to customize labels.
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 Geographics Word Template.
Search by item number in the blue search box. Click the download template link and save the file 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).
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 described 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.
MAIL MERGE WITH WORKS FILES
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.
PRINTER SETTINGS SELECTION
Print Settings may vary from printer to printer. Manually make the desired adjustments.
We recommend printing test pages on plain paper before printing on the actual Geographics stationery.
What can you adjust in your local printer settings?
Page orientation - portrait or landscape
Color - Black & White or Color.
Print borderless (Limitations apply to different printers). All Photo Printers have the capability to print borderless. These settings are good for E-Z Print projects
If you encounter any issues using Iclicknprint 2018 beta version, please report them in the Forum.
voice your suggestions and reconmmendations there, as well.
For urgent matters, contact customer service through our online chat or
Call 203-644-1270; 203-644-1271, Toll Free 1-800-436-4919.
You can e-mail us at email@example.com or send a message through the chat.
We we will get in touch with you, as soon as possible.
Thanks for buying Geographics® and Royal Brites® products!