Outlook Archives - PK: An Excel Expert

Download attachments form multiple emails

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: Range in Outlook Body

June 7, 2018October 9, 2026 PK0

With a short Excel VBA macro you can send an email with a snapshot of your worksheet: the text, charts, pictures and tables in a range land in the body