📝 How to Print a Filled Cheque from Excel Using Mail Merge in Word

🔧 Files Required:

1. Cheque Details.xlsx – Contains cheque data (Name, Date, Amount, etc.)
2. Cheque Print.docx – Word template for cheque layout
3. NumbertoWord.xlam – Excel add-in to convert numbers to words

Download the files : Click me

✅ Step 1: Download the Required Files

Download all the shared files from Google Drive and save them on your PC. For best results:

• Save the Excel and Word files in the same folder (e.g., C:\ChequePrint)
• Save the Excel add-in (NumbertoWord.xlam) in the Add-ins folder:

C:\Users\DELL\AppData\Roaming\Microsoft\AddIns

✅ Step 2: Enable the Excel Add-In (Number to Word)

1. Open Excel.
2. Go to File → Options → Add-ins.
3. At the bottom, select Excel Add-ins and click Go.
4. Click Browse, navigate to the location where you saved NumbertoWord.xlam, and select it.
5. Check the box next to NumbertoWord and click OK.

This will allow you to use the function =NumberToWords() in your Excel file.

Note Skip 3 & 4 Step which already followed in the Cheque Princt.docx if you are making New then follow the following Steps

✅ Step 3: Prepare Cheque Data in Excel

Open Cheque Details.xlsx and make sure it includes the following columns:

• Name
• Date
• Amount
• AmountInWords (use =NumberToWords(Amount) formula)

Example:

Name	Date	Amount	AmountInWords
John Smith	21-May-2025	1200	One Thousand Two Hundred Only

✅ Step 4: Set Up the Word Cheque Template

Open Cheque Print.docx in Microsoft Word.

1. Go to Mailings → Select Recipients → Use an Existing List.
2. Select your Cheque Details.xlsx file.
3. Insert Merge Fields:
   • Use Insert Merge Field to place Name, Date, Amount, and AmountInWords into the cheque layout.
   • Align fields according to your cheque format.

✅ Step 5: Preview and Print the Cheque

1. Go to Mailings → Preview Results to verify how the cheque will look.
2. If everything looks correct, click Finish & Merge → Print Documents.
3. Select the cheques you want to print and send them to the printer.

🖨️ Tips for Accurate Printing:

Use a test page with plain paper to align the cheque layout correctly.

• Adjust margins and field positions if needed before printing on actual cheque leaves.