i have about ten responses from StackOverflow open but none of them quite answer my problem. i have created several UserForms in Excel VBA for this particula
The MailItem.SenderEmailAddress and MailItem.To fields are coming through as null unless I run Outlook at admin. How can I get the sender's email address and t
I have code to track changes in the Category of emails in a Public (Shared) Folder. I have set up the code to be able to switch it "on/off", and this code is in
I have a worksheet that uses randomly generated numbers in calculations to produce results in two adjacent cells (let's say A1 and A2). I am trying to perform
I’m trying to create a series of input boxes that will prompt for more information before executing the rest of the code. I’m stuck on the looping a
Below is my code where I'm trying to export a MS Access query output to an Excel file and then editing the Excel to create a pivot table on a new sheet. The cod
I am trying to apply filter from a master worksheet to multiple worksheets in the same workbook. eg. There are 3 worksheets in the workbook, with following fi
I am trying to export a MS Access query to an Excel file and then create pivot tables in the excel file based on the data dump extracted to the excel file. My i
In Workbook.Open() I have an Application.OnKey for every letter on the keyboard and all the numbers. The letters open a sub LetterPress(L as String) Example for
I'm trying to turn general data written as fractions like 3/4" or 13 7/32" into 3 place decimal numbers such as 0.750 or 13.219. I have a working table replacem
The code works when the criteria exists. I get an error when the criteria doesn't exist. ' Define constants. Const srcName As String = "wfm_rawdata" Const srcFi
By default, my MS Outlook 2013 is set NOT to download images in received HTML e-mail messages. I would like to keep this setting. There are some senders whose
I'm referring Parent class from Child class; instead of simply do, for example: Public Property Set Parent(obj As ClassProperties) Set this.ParentColl = ob
I am trying to extract the email address from each individual undeliverables email body. The email body would be like: ----------------------------Email-------
I would like to use Microsoft ScriptControl to parse a JSON string in VBA, and then transform the resulting Object into Dictionary and Collection objects. I alr
I am creating a Word document which contains macros that will convert the .doc to .PDF, and include it as an attachment in an autogenerated Outlook email contai
I know the method as Application.Visible = False and Application.Screenupdating = False When opening the file, I want the user to see only the userform. The
I'd like to move the selected email to the "Junk Email" folder and create a spam rule for that email address that automatically sends all future emails from tha
I have an Excel document consisting of data imported into multiple tabs. The columns in each tab are stretched out and hard to read. I am trying to cycle throug
The code is intended to add the same hyperlink to all Heading 1 style text. (Purpose: clicking any heading brings you to the top of the document). It works for