I haven't done it with WhatsApp , but you'll probably need to use Twilio or the WhatsApp Business API.

The customer does have WhatsApp Business API.

I'd look through their documentation then, but it should just be like a normal API call then, unless it needs some crap like JWT authentication.

I am hoping somebody has already done the.

I will be happy to pay for it.

Ah OK, if not, I'd be happy to try to take a shot at working on it with you if you wanted. Although I'm sure you could figure it all out ;).

Here's some useful information. https://developers.facebook.com/docs/whatsapp/

There was some talk about it many years ago if you search the forum but I don't think anyone got it working or shared code if they did.

Adam, I will email you after the holidays regarding this.

I asked this question a couple of years ago.  I am still interested if anyone has a solution

Hi Sami,

I have setup a whatsapp account, but it is a lot of work to get all the right credentials working, and its not free, Meta is charging for each message send, you need a business account on facebook, once setup i could send messages from Access.

Details

    ' Set de API Token
    apiToken ="E....D"
    
    ' Set de API Endpoint
    url = "https://graph.facebook.com/v20.0//messages"

    phoneNumber = "324...."
    message = "Hallo, test from Access!"
    JSONBody = "{""messaging_product"": ""whatsapp"", ""to"": """ & phoneNumber & """, ""type"": ""template"", ""template"": {""name"": ""afhaling"", ""language"": {""code"": ""nl"" } } }"
    Set http = CreateObject("MSXML2.ServerXMLHTTP.6.0")

    http.Open "POST", url, False
    http.setRequestHeader "Content-Type", "application/json"
    http.setRequestHeader "Authorization", "Bearer " & apiToken
    http.Send JSONBody
    responseText = http.responseText
Copy

Thank you Mark,
This very helpful