Automated Payment Reminders from Excel (WhatsApp/Email)

Q: Can Excel send WhatsApp messages automatically?

Not on its own. Excel builds the message and a `wa.me` click-to-chat link; you click to open the pre-filled chat and send. Full auto-send needs an add-in or API, but one-click manual sending keeps you within WhatsApp's rules.

Q: How do I write the reminder text automatically?

Join your row data with `&` in a cell, e.g. `="Dear "&Customer&", invoice "&InvNo&" for ₹"&TEXT(Balance,"#,##0")&" is overdue."` Copy down and every invoice has its own message.

Q: Is the workbook free?

Yes — free to download, no sign-up. ---

Last updated: 27 June 2026 · Reminder schedule, message templates and a free workbook.

You can run payment reminders straight from Excel: keep one sheet of unpaid invoices with due dates, let a formula decide which customers are due for a follow-up today, and auto-build each reminder's WhatsApp or email text with a TEXTJOIN/& formula you copy and send. Excel won't press "send" by itself, but it removes the real work — deciding who to chase and writing each message — so a 30-minute chore becomes a two-minute one.

Key takeaways

Drive reminders off your receivables tracker — the same invoice list, plus a reminder schedule.
A reminder stage formula picks the right message: due-soon, day-1 overdue, 15-day, 30-day.
Build the message text in a cell with ="Dear "&Customer&", invoice "&InvNo&"…" so each row is ready to copy.
Email at scale: Word Mail Merge reads the Excel sheet and sends one personalised email per row.
WhatsApp: use a wa.me/<number>?text=<message> link to open a pre-filled chat in one click.
Polite, scheduled, written reminders get paid faster than ad-hoc phone calls — and leave a record.

Fact box. A reminder cadence — for example a gentle note 3 days before due, a follow-up on day 1 overdue, then day 15 and day 30 — collects more than a single chase. Excel's job is to tell you which stage each invoice is at today.

Can Excel send reminders automatically?

Excel itself does not send WhatsApp messages or emails on a schedule — that needs a tool that can press "send". What Excel does brilliantly is the decision and the drafting: it flags which invoices are due for a reminder today and writes each customer's message for you to copy or mail-merge. For true hands-off sending you either use Word Mail Merge (email), a wa.me link (WhatsApp, one click per chat), or an add-in like Ankeshan that automates the send inside Excel.

How do I decide who to remind today?

Add a reminder schedule to your invoice list using the days-overdue column. A simple staged formula:

=IF(Balance=0,"",
 IF(DaysOverdue>=30,"30-day notice",
 IF(DaysOverdue>=15,"15-day reminder",
 IF(DaysOverdue>=1,"Overdue reminder",
 IF(DaysToDue<=3,"Due-soon reminder","")))))

Where DaysOverdue = MAX(0, TODAY() − DueDate) and DaysToDue = DueDate − TODAY(). Any row with a non-blank stage is on today's list. Filter the column to show only those rows and you have your daily follow-up list.

Fact box. TODAY() recalculates every time the file opens, so the reminder-stage column re-sorts your follow-ups automatically each morning — no manual date-checking.

How do I auto-write the reminder message in Excel?

Build the message in a cell by joining text with the row's data, using & (or TEXTJOIN):

="Dear "&[Customer]&", this is a gentle reminder that invoice "&[InvNo]
&" dated "&TEXT([InvDate],"dd-mmm-yyyy")&" for ₹"&TEXT([Balance],"#,##0")
&" is overdue by "&[DaysOverdue]&" days. Kindly arrange payment at your earliest. Thank you."

Copy down and every row holds its own ready-to-send text. Use TEXT() to format dates and rupee amounts cleanly inside the string. Keep the tone polite and factual — it doubles as a written record.

A three-stage message set works well:

Stage	Tone	Core line
Due-soon	Friendly heads-up	"…falls due on [date]. Just a reminder."
Overdue (1-14 days)	Polite chase	"…is now overdue. Kindly arrange payment."
30-day	Firm, still courteous	"…remains unpaid for 30 days. Please clear it to avoid disruption."

How do I send the emails (Mail Merge)?

Word Mail Merge turns the Excel sheet into one personalised email per row:

In Excel, keep columns for Customer, Email, Invoice No., Amount, Due Date, Days Overdue.
In Word: Mailings → Start Mail Merge → Email Messages.
Select Recipients → Use an Existing List → pick your Excel file/sheet.
Write the email and insert «Merge Fields» where the customer name, invoice and amount go.
Finish & Merge → Send Email Messages, choosing the Email column and a subject line.

Word sends through Outlook — one tailored email per overdue customer, in a single action.

How do I send WhatsApp reminders from Excel?

Use a click-to-chat link. WhatsApp opens a pre-filled message to that number with one click:

Build the link in a cell: ="https://wa.me/91"&[Phone]&"?text="&ENCODEURL([MessageText]) (use the customer's 10-digit number after the 91 country code).
ENCODEURL() safely encodes spaces and symbols so the message survives the link.
Click the link — WhatsApp Web or the app opens the chat with your message ready; press send.

This is one click per customer (manual send), which keeps you compliant with WhatsApp's rules and lets you glance before sending.

A free payment-reminder workbook is available to download, no sign-up — invoice list, reminder-stage formula, message templates and the wa.me builder, ready to use.

How Ankeshan helps: Ankeshan watches your overdue invoices inside Excel and drafts WhatsApp and email reminders at the right stage for each customer — you review and send, with the whole cadence tracked. It's launching soon; join the waitlist.

Frequently asked questions

Can Excel send WhatsApp messages automatically? Not on its own. Excel builds the message and a wa.me click-to-chat link; you click to open the pre-filled chat and send. Full auto-send needs an add-in or API, but one-click manual sending keeps you within WhatsApp's rules.

How do I send bulk payment reminder emails from Excel? Use Word Mail Merge: point it at your Excel invoice sheet, insert merge fields for name, invoice and amount, then Finish & Merge → Send Email Messages. It sends one personalised email per row through Outlook.

How do I write the reminder text automatically? Join your row data with & in a cell, e.g. ="Dear "&Customer&", invoice "&InvNo&" for ₹"&TEXT(Balance,"#,##0")&" is overdue." Copy down and every invoice has its own message.

How often should I send reminders? A common cadence is a heads-up 3 days before due, a follow-up on day 1 overdue, then day 15 and day 30. Scheduled, polite, written reminders collect faster than occasional phone calls.

Is the workbook free? Yes — free to download, no sign-up.

Sources

Microsoft Excel function reference — TEXT, TEXTJOIN, ENCODEURL, TODAY, IF: support.microsoft.com.
Microsoft Word Mail Merge documentation: support.microsoft.com.
WhatsApp click-to-chat (wa.me) link format: faq.whatsapp.com.

General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.