Project Description
I need a single Excel workbook that lets me broadcast personalised WhatsApp Business messages straight from the sheet. Core flow is simple:
• I drop or paste a contact list into a dedicated sheet (structure: phone number, name, any merge fields you feel are useful).
• I type one master message that can pull those merge fields so every recipient gets a tailored text. For this first release we will stick to text-only messages; later on I may ask you to extend it to images or documents, so please keep the code modular.
• When I hit “Send”, your VBA (or Office Script) routine should call the official WhatsApp Business API, handle authentication, queue the messages and confirm each send.
Stability is key. The workbook must trap API errors, surface clear status messages, and record anything that fails so I can retry without re-sending everything. A clean, button-driven ribbon panel or userform interface will make it friendly for non-technical staff.
Deliverables
1. Unlocked Excel file with documented code.
2. A short setup guide showing how to plug in my WhatsApp Business credentials.
3. Brief video or screenshots demonstrating a successful bulk send and error capture.
If you’ve built similar API integrations in VBA or Power Query, let me know; I’d like to see them before awarding.