I generate an email in vba and send it. I have a class which includes the send event for that email so I am able to tell if the email has been sent. My issue is
Is there a way to tell if some dynamic array, for example arr() as String is initialized? IsEmpty and IsNothing seems not to work with dynamic arrays. Currently
I set up a custom domain for my Microsoft 365 business account ("@company.com" is the custom domain which is really "@company.onmicrosoft.com"). I have two othe
I know this is a topic that is talks about a lot, but I just cant find the answer. I have a range. if in that range there is a word then I need it to go to the
I'm trying to pull a set of five emails from a specified Outlook folder based on two conditions - the (partial) subject line, and received between two specified
I wrote vba script to duplication my main calendar to another calendar, including recurring meeting. All is well except when the organizer do out-of-order modif
My workbook consists of 2 sheets: Sheet1 is the primary dashboard that the user sees, while Sheet2 consists of a pivot table and regular table. I'd like to imp
I have the below code for one of my financial reports and I'm struggling with updating the code to make it more automated. The code creates a string of the colu
I am trying to run a python function called comments() from vba and getting an error with the following code due to spaces in the file name: Sub notes() Dim f
Code: Dim Application As Object, namespace As Object Set Application = CreateObject("Outlook.Application") Set namespace = Application.GetNamespace
I'm using Outlook 2016 and I have two PST files listed below my default Exchange mailbox/store. In the Folder Pane, I can click and drag the PST mailbox/store a
Using excel macro The first line is the json file name, and the second and subsequent columns are the values. With the first column as the key to the json obj
So i've been trying to wrap my head around this for weeks now and have tried many things but nothing that works for my case, I have two sheets with "similar" St
I am trying to test a cell for specific data. If it contains that data, I do not want my code to run (because that would leave my worksheet and workbook Unprote
I'm having a seemingly basic problem but can't find any resources addressing it. Simply put, I just want to load the contents of a Range of cells (all one colu
I have an Excel file that uses VBA to calculate active ranges for a few sheets to make a .csv file to be picked up by a reporting server. Every once in a while,
I'm writing some code in which the user will need to pick both a source folder and destination folder using: Set SourceFolder = GetObject("", "Outlook.Applicat
I have an Excel with an embedded image. How can I send it by mail using the name of the image? I do not want to send it attached, I want to embed it in the htm
I'm exporting/extracting mail failure items located in a subfolder named 'Subfolder' to a local folder on my laptop using this Outlook code: Private Sub DBC1()
I cobbled together a script and rule to save incoming emails as .txt files on our server. It works for about a day or two, but then stops working until I delete