In this article, we have created an Excel template to send WhatsApp and Email without using VBA coding. We have used the Hyperlink formula to achieve this.
You can use the Hyperlink formula to open the email as given below. Just change the Email id, Subject, and body as per your requirements.
=HYPERLINK("mailto:xxxxxx@yyyy.com?Subject=xxxxxx&body=xxxxxx","Send Email")
You can use the Hyperlink formula to open the WhatsApp chat window in your default web browser. You need to change YY with country code and XXXXXXXXXX with mobile number. Change the default text also. For the first time, you need login into your web WhatsApp after scanning the QR code.
=HYPERLINK("https://web.whatsapp.com/send?phone=%2BYYXXXXXXXXXX&text=SomeText&app_absent=1&send=1","Send WhatsApp")