Ultimate Guide to Write Christmas Thank-You Letters and Envelops in Bulk with iAuto Automatic Handwriting Machine

1. Copy the thank-you letter content into an Excel sheet, clearly marking the customer details such as Name, Company, and Address in separate sections for easy extraction later.

2. Open the customer information file, arrange the details in the order they appear in the letter, and paste it after the letter content in the same sheet.

3. As shown in the example, separate the letter content based on customer information fields like Name, Company, and Address, and paste each section into separate columns. Then, copy the content of each column to fill the other rows accordingly.

• Important Notes:
  • Ensure you retain spaces, punctuation, and formatting exactly as they appear in the original letter.
  • The way it looks in Excel will directly reflect in the final template.

4. Delete the header and the first column (content), then save the file under a new name.

5. Open iAuto and switch to Table mode. Create a new paper size matching your letter paper.

• If the default sizes don’t fit, you can manually add a custom size.

6. Add two text boxes: one for the salutation, the other for the letter body and signature.

• Adjust the size, position, font style, and other formatting as needed.
• Ensure there is at least a 0.5 cm margin on all sides to prevent content from being cut off.

7. Bind Content to the Text Boxes:

• Select the first text box, open the Attribute window, and click the Binding button.

• Once linked, a pop-up will confirm how many pages have been generated.

2. Preview the pages by clicking the page numbers and check if all content is displayed correctly.

• Tip: Identify the row with the longest content and verify it displays properly (e.g., check Page 2 if row 2 is the longest). Adjust the text box size or formatting if needed.

3. Generate the G-code file for all pages by clicking All in the Write section.

• Click Write to start writing the letters.

4. Here are the results

Part 3: Preparing the Christmas Thank You Envelope Template

1. Similar to the letter, prepare a two-column file in Excel, then save the file locally.
   1. Column 1: Customer's Name
   2. Column 2: Customer's Address

2. In iAuto Software, create a new paper size matching your envelope. Add three text boxes:
   1. One for the sender's information (static).
   2. Two for the recipient's name and address.

3. Bind the text boxes:
   1. Bind the second box to the recipient’s name.
   2. Bind the third box to the recipient’s address.

4. Link the customer information file to the template, similar to the letter process.

5. Preview each page to ensure all details are displayed correctly, particularly for longer addresses.

6. Once verified, generate the G-code files for all envelopes and start the writing process by clicking All and then Write.

7. Final results

Part 4: Special Considerations for Christmas Thank You Envelopes

1. If the envelope gets jammed during writing, it may be too thick. Measure the envelope’s unfolded size and sealing flap width.

2. Create a new envelope template in iAuto software based on the unfolded dimensions.

3. When placing text boxes, leave enough space for the flap—this area should remain blank.

4. In order to advoid paper jamming during the writing process, try rotating the envelope 90 degrees and writing vertically: After setting up the envelope template, click the Rotate 90° button at the bottom of the software.

       When placing the envelope, make sure the flap is on the left and the front side is facing up before loading it into iAuto.

Summary