Automation Archives

How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI

January 30, 2023January 30, 2023 PKComments Off

Introduction Have you ever tried to write a complex Excel function, VBA code, or DAX using natural language? It can be challenging and time-consuming. If this is your situation, then

VBA

Make same size of selected shapes/Charts/Pictures using single click

August 16, 2022August 16, 2022 PKComments Off

In this article, we have created a macro to make the same size of the selected shapes, charts, or pictures. It will change the size accordingly to first object in

VBA

Automatic Data Transfer Excel to PowerPoint

July 27, 2022July 27, 2022 PKComments Off

In this article, we have created an Automation to transfer the data from Excel to PowerPoint. You can click on Create PPT button after filling the data in to different

Templates VBA

Automated Multiple Emails with Multiple Attachments and “From” option

May 30, 2022September 18, 2022 PKComments Off

In this article, we have created an Automated Bulk Emailer with Multiple Attachments and the "From" option. You can choose the Send or display option buttons. We have given a

Templates

Send WhatsApp and Email without VBA

January 17, 2022March 3, 2023 PKComments Off

In today's fast-paced world, communication has become an integral part of our lives. We need to stay connected with our colleagues, friends, and family. WhatsApp and Email are two of

Templates VBA

Automatic Invoice Creator V1.0

July 18, 2021July 18, 2021 PKComments Off

Automatic Invoice Creator V1.0 is a useful template to create multiple invoices in Excel and PDF format. There are three worksheets in this Automation file. 1-Setting: In this worksheet, you

VBA

Hourly Auto Email with Scheduler

November 1, 2020November 15, 2020 PKComments Off

In this article, we have created an automation to send everyday auto multiple emails using scheduler in Excel VBA. We have used Microsoft Outlook to send the multiple email using

VBA

Bulk Auto Emailer with Picture Signature and HTML body

September 20, 2020September 20, 2020 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

Templates VBA

Send bulk emails using VBA and Outlook

July 6, 2020July 6, 2020 PKComments Off

In this article, we have create an automation for send multiple emails on one click. This automation will send the emails using Microsoft Outlook. Watch the step by step video

Power Pivot VBA

Email Data Consolidation Tool in Excel

April 26, 2020February 27, 2023 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