Excel VBA WhatsApp Sender

I want a single-click Excel workbook that lets me load a list of phone numbers, type a unique message beside each one, attach one common document, and then watch the macro shoot everything out through WhatsApp Web. The routine only needs to target individual numbers; there is no group handling required.

Key flow I have in mind: I paste numbers and custom text into a sheet, point the macro at a PDF or DOC that will be the same for everyone, hit a “Send” button, and the code loops—opening WhatsApp Web, sending the tailored message plus the attachment, recording success or any errors back into the sheet. I should be able to restart the process if it stops, so a simple status flag for each row would help.

Please write clean, well-commented VBA so I can tweak things later, and rely only on standard references (or late-binding) to keep setup painless. The finished file should work in the latest desktop Excel for Windows and be ready for me to test with a small list before rolling out to a larger batch.