How to Batch Write Personalized Letters with UUNA TEK 3.0 Pen Plotter

How to Batch Write Personalized Letters with UUNA TEK 3.0 Pen Plotter

The UUNA TEK 3.0 Pen Plotter allows you to create personalized letters efficiently by combining a letter template with Excel data. With the Binding and batch data functions, variable information such as recipient names and customized messages can be automatically applied to multiple pages.

1. Prepare the UUNA TEK 3.0 Software

Make sure the UUNA TEK 3.0 software is installed on your computer. If not, complete the software installation before starting this tutorial.Please refer to the following tutorial for the software installation video.

https://youtu.be/7tm-ODfqx6w?si=jqZL_KMuHowb8qK7

https://youtu.be/4Hk-UeLSgrs?si=vLd5yn-1-57xSy_N

Open the software and select the appropriate paper size. This tutorial uses A5 paper as an example.

2. Add and Edit Letter Content

Click “Add Text”, enter the required text in the editing window, and click “Add” to confirm.

The added content will appear as a text box on the canvas.

Drag the text box to the desired position. Use the top parameter settings to adjust the font, font size, character spacing, and line spacing. Repeat these steps until the complete letter layout is ready.

3. Bind Variable Content to Excel

Prepare an Excel spreadsheet containing the information that needs to change between letters, such as recipient names and personalized messages.

Select the text box that needs to change, open the property panel, and click “Binding.” Enter the corresponding cell reference according to the Excel data position. For example, if recipient names are stored in Column A, enter A1 and confirm.

For other variable content, repeat the same process. For example, if the personalized letter body is stored in Column B, bind it to B1.

4. Import Batch Data

  1. Click “Batch application data” on the left side.
  2. Under the batch type, select “A table in a file has multiple pages (applicable to many pages in one sheet)”, then click “Next.”
  3. Select “Splitting with Rows” as the splitting method, then click “Next.”
  4. In the pop-up window, click “Browse files”, select and open the prepared spreadsheet file, then continue clicking “Next” until the import is complete.

5. Preview and Write the Letters

1.Use the page navigation controls to preview the generated letters. Check that recipient names, personalized content, and text positions are correct.

2.Place the paper and writing pen on the UUNA TEK 3.0 Pen Plotter and connect the machine to your computer. Click “Write” on the right side of the software to start writing the current page.

3.After the first letter is completed, check the physical result.

4.Replace the finished sheet with a new sheet, switch to the next page in the software, and click “Write” again. Repeat this process to complete the remaining personalized letters.

Key Points

  • Enter fixed text directly into the template.
  • Use Binding for changing content such as names and personalized messages.
  • With Splitting with Rows, one Excel row corresponds to one letter.
  • Preview the pages before starting the full batch.
  • Replace the paper manually after each completed letter.

Conclusion

Using the UUNA TEK 3.0 Pen Plotter, you can combine a reusable letter template with Excel data to create personalized letters more efficiently. The basic workflow is:

Create the template → Bind variable content → Import Excel data → Preview → Write.

This workflow can be used for personalized letters, thank-you notes, invitations, direct mail, greeting cards, and other pen-writing projects.

UUNA TEK Halloween 2026 Special Sale – Up to 35% OFF

UUNA TEK Halloween Sale runs from September 8 to October 31, 2026. Enjoy limited-time savings on pen plotters and automatic writing machines, plus a chance to win an iAuto Plus 2.0 automatic writing machine.

  • Halloween Bundles: Up to 35% OFF
  • Weekly Flash Deals: 30% OFF selected models
  • iDraw Pen Plotters: From $489
  • iAuto Series: From $2,799
  • Giveaway: Win an iAuto Plus 2.0 worth $8,999
  • Free Shipping + 1-Year Warranty + Lifetime Support

Shop UUNA TEK and explore limited-time Halloween offers before October 31.

Related Articles:

UUNA TEK 3.0 Pen Plotter Multicolor Drawing Tutorial

UUNA TEK 3.0 Pen Plotters WiFi Network Configuration Instructions

How to Use LightBurn to Control UUNA TEK 3.0 Pen Plotters

How to Convert Any Photo to SVG and Draw It with the UUNA TEK 3.0 Pen Plotter

Retour au blog

Laisser un commentaire

Veuillez noter que les commentaires doivent être approuvés avant leur publication.