Every Friday, I need to send two emails to other teams at work. Although the emails are straightforward, drafting them each week is time-consuming and prone to errors. Below are some requirements for these emails:
After repeating this task for several weeks, I sought a way to automate the process. Chatgpt helped me generate the following VBA code to streamline the workflow,
Now, with the click of a button in Outlook, the VBA code automatically generates the email, and I simply click the Send button. This automation saves me approximately 30 minutes each week.