How to send messages to a WhatsApp group in Visual Basic Script / VBA

Using the WhatsMate WA Gateway REST API

This article shows you how to send a message to a WhatsApp group in VBA / Visual Basic Script.

You MUST obtain the secret gateway number by signing up for a Forever Green account before you can send a message to a WhatsApp group. Instructions are available on the official site.

To send a WhatsApp group message in VBA / VB Script, do this:

  1. Create a new group with a unique name. The API won’t work if it’s not unique.
    • Create a new WhatsApp group

  2. Add the secret gateway to the group.
    • Name the WhatsApp group

  3. Say “Hi” to the group to let the gateway recognize the new group.
  4. In your Excel / Access / VBA development environment, define the following subroutines:
  5. Customize the TODO lines in the VB Script program:
    • Specify your gateway instance ID on line 17.
    • Specify your Client ID and Client secret on lines 18 and 19.
    • Specify the group admin number (i.e. your WhatsApp number including the country code) on line 2.
    • Specify the group name (e.g. Happy Club) on line 3.
    • Specify the content of the message on line 4.
  6. Run it.

As mentioned at the beginning of this tutorial, you will need a trial account to call the above API. Go sign up now.

Happy coding :)