

To merge data click Merge - the next tab after review | New Page. To add a new page, click Preview | New Page - the next tab after Edit. To use a ready-made template, choose it from the left menu - Templates.Īdd Clip Art, Suggested Wording, Shapes and Lines. To display fonts dynamically, check the hover over box and scroll down over fonts until you like the choice. To Edit Text, change font, size & color, highlight the text and edit it using the right Edit tab features. To add a new text box, click T Text - see top menu. All the rest will look the same bur will contain the data imported. Merge will add extra pages in your project. Use Merge to import data only when the project you are customizing looks exactly like what you want to print. Otherwise, you will have to do the editing in each sheet, after merge. ie Student Name, Achievement, etc.Įdit fonts, colors, font sizes, before merging the data. This saves you some work since you do not have to resize the text boxes to fit the text.Īrrange your text boxes and images in the exact positions you want them to be on the printed product.Īlternately, name each textbox so you know what data to drag and drop there. After the merge is done, the text box sizes remain unchanged. It will offer guidance as to what data to drag and drop in each text box.Ģ.

RECOMMENDED: Enter in each text box the longest text from each Excel file column.ġ. In ICLICKNPRINT, your project should contain all the text boxes that will receive the Excel or CSV data. You can add to your project only data from the columns you need. Note that your Excel file can contain columns that will not be imported. Prepare your Excel or CSV file as follows: Remove any headers and prepare the data in sheet 1.Įach column should contain specific data, ie.
