Templates

Send WhatsApp and Email without VBA

Send WhatsApp and Email without VBA

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.

Send WhatsApp and Email without VBA

 

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")

 

Watch the step-by-step video tutorial:

Click here to download the practice file.

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com