Home>Templates>Automated Address Book with Auto WhatsApp and Email
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.

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!