Workbook CRUD

Customer Message Table

Grouped by message mode, cleaned for dropdown-based editing, and saved back to C:\inetpub\msg.learninburmese.com\LIB_Msg_Service_2026_03_18_AM\Data\customerlist.xlsx.

Editing Guide

Recommended dropdown fields

Channel: line / whatsapp Send Mode: Send Now / Send Later / Invoice Message Need Attachment: Yes / No Status: Pending / Done / Failed Invoice Status: Paid / Unpaid

Send Now

Immediate one-time sends that can also trigger follow ups.

Customer	Send Setup	Invoice	Messages	Follow Up	Status & Log
Code Name Recipient	Channel Send Mode Enabled Need Attachment	Invoice File Invoice Date Scheduled DateTime Invoice Status Previous Month Status	Normal MessageHello Invoice MessageHello Testing အစမ်းပို့တာ Previous Month MessageYour previous month invoice is still ##PreviousMonthInvoiceStatus##. Please help to settle it. Thank You MessageThank you ##CustomerName##. We received your payment for ##CurrentMonthName## ##CurrentYear##.	Follow Up Need Follow Up MessageHello Testing အစမ်းပို့တာ Every Days Max Follow Ups	Sent Status Sent DateTime Sent FollowUp Count Send DateTime Log1(13/03/2026 15:05) /2(25/03/2026 15:05) \| TEST(2026-03-15 01:37) \| INITIAL(2026-03-15 01:40) \| TEST(2026-03-15 01:41) \| INITIAL(2026-03-15 01:58) \| INITIAL(2026-03-15 01:59) \| THANKYOU:2026-03 \| TEST(2026-03-17 02:28)
Code Name Recipient	Channel Send Mode Enabled Need Attachment	Invoice File Invoice Date Scheduled DateTime Invoice Status Previous Month Status	Normal MessageHello ##CustomerName##, this is a WhatsApp test message for ##CurrentMonthName## ##CurrentYear##. Invoice MessageHello ##CustomerName##, this is your WhatsApp invoice message for ##CurrentMonthName## ##CurrentYear##. Previous Month MessageYour previous month invoice is still ##PreviousMonthInvoiceStatus##. Please help to settle it. Thank You MessageThank you ##CustomerName##. We received your payment for ##CurrentMonthName## ##CurrentYear##.	Follow Up Need Follow Up MessageHello ##CustomerName##, this is a WhatsApp follow up reminder for ##CurrentMonthName## ##CurrentYear##. Every Days Max Follow Ups	Sent Status Sent DateTime Sent FollowUp Count Send DateTime LogTEST(2026-03-17 02:46) \| INITIAL(2026-03-17 02:51) \| TEST(2026-03-17 09:43) \| TEST(2026-03-18 02:17) \| TEST(2026-03-18 02:27)

Send Later

Scheduled one-time sends that wait for Scheduled DateTime.

Customer	Send Setup	Invoice	Messages	Follow Up	Status & Log
Code Name Recipient	Channel Send Mode Enabled Need Attachment	Invoice File Invoice Date Scheduled DateTime Invoice Status Previous Month Status	Normal MessageHello ##CustomerName##, this is your invoice update for ##CurrentMonthName## ##CurrentYear##. Invoice MessageHello Testing အစမ်းပို့တာ Previous Month MessageYour previous month invoice is still ##PreviousMonthInvoiceStatus##. Please help to settle it. Thank You MessageThank you ##CustomerName##. We received your payment for ##CurrentMonthName## ##CurrentYear##.	Follow Up Need Follow Up MessageHello Testing အစမ်းပို့တာ Every Days Max Follow Ups	Sent Status Sent DateTime Sent FollowUp Count Send DateTime LogSCHEDULED(2026-03-15 01:37) \| THANKYOU:2026-03

Invoice Message

Monthly recurring invoice messages with previous-month reminders and thank-you handling.

Customer	Send Setup	Invoice	Messages	Follow Up	Status & Log
Code Name Recipient	Channel Send Mode Enabled Need Attachment	Invoice File Invoice Date Scheduled DateTime Invoice Status Previous Month Status	Normal MessageHello ##CustomerName##, this is your invoice update for ##CurrentMonthName## ##CurrentYear##. Invoice MessageHello Testing အစမ်းပို့တာ Previous Month MessageYour previous month invoice is still ##PreviousMonthInvoiceStatus##. Please help to settle it. Thank You MessageThank you ##CustomerName##. We received your payment for ##CurrentMonthName## ##CurrentYear##.	Follow Up Need Follow Up MessageHello Testing အစမ်းပို့တာ Every Days Max Follow Ups	Sent Status Sent DateTime Sent FollowUp Count Send DateTime LogINVOICE:2026-03
Code Name Recipient	Channel Send Mode Enabled Need Attachment	Invoice File Invoice Date Scheduled DateTime Invoice Status Previous Month Status	Normal MessageHello ##CustomerName##, this is your invoice update for ##CurrentMonthName## ##CurrentYear##. Invoice MessageHello Testing အစမ်းပို့တာ Previous Month MessageYour previous month invoice is still ##PreviousMonthInvoiceStatus##. Please help to settle it. Thank You MessageThank you ##CustomerName##. We received your payment for ##CurrentMonthName## ##CurrentYear##.	Follow Up Need Follow Up MessageHello Testing အစမ်းပို့တာ Every Days Max Follow Ups	Sent Status Sent DateTime Sent FollowUp Count Send DateTime LogINVOICE:2026-03