Address Book in Excel
Templates VBA

Automated Address Book with Auto WhatsApp and Email

In this article, we have created an Automated Address Book using the VBA user form. You can enter the contact information for a person like – Name, Mobile Number, Whatsapp Number, Email and Address, etc. You can Edit, Delete the information using the buttons.

Address Book in Excel
Address Book in Excel

You can search by any field like Name, Mobile Number, Whatsapp Number, Email, Address, or Comments.

Search By
Search By

There are 3 useful buttons are available on this form-

Feature Buttons
Feature Buttons

1) Export to Excel:

After clicking on this button, you export the data into a new Excel file.

2) WhatsApp:

You can send Whatsapp without saving the number in the contact list. After clicking on this button it will open the web Whatsapp chat window in the browser. For the first time, it will ask to log in through a QR code.

3)Email using Outlook:

It will open a new blank email wherein the related email id will be in “TO”. You can quickly send the email.

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