Outlook Archives - PK: An Excel Expert

Download attachments form multiple emails

VBA

Download Attachments from Multiple Emails Automatically using VBA

June 21, 2023February 18, 2025 PKComments Off

Automation has become an integral part of our everyday lives, especially in the realm of business. Among many automation tools, Visual Basic for Applications (VBA) stands out for its utility

Templates VBA

Automated Address Book with Auto WhatsApp and Email

January 4, 2022February 18, 2025 PKComments Off

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

VBA

Hourly Auto Email with Scheduler

November 1, 2020February 18, 2025 PKComments Off

In this article, we have created an automation to send everyday auto multiple emails using scheduler in Excel VBA. This Hourly Auto Email with Scheduler automation required Microsoft Outlook to

VBA

Bulk Auto Emailer with Picture Signature and HTML body

September 20, 2020February 18, 2025 PKComments Off

In the article, we have created a Bulk Auto Emailer with Picture Signature and HTML body. We have given the 2 form control option button to select the send or

Power Pivot VBA

Email Data Consolidation Tool in Excel

April 26, 2020February 25, 2025 PKComments Off

Now a days businesses rely more heavily on email communication. Managing data from multiple sources can become a real challenge. Fortunately, there is a solution: an email data consolidation tool

VBA Templates

Automated Bulk Emails Form in Excel VBA

February 2, 2020February 24, 2025 PKComments Off

In this article, we have created an Automated Bulk Email User form to send the bulk emails using Microsoft Outlook. We have taken two different type of emails – Customer

VBA Templates

Send Email with Snapshot in Excel VBA

June 7, 2018February 25, 2025 PK0

In this article you will learn how to send an Outlook Email with mail body snapshot like Excel tables, Charts or images by using VBA. We will use "Mail Envelope" method