Category "vba"

VBA: how can I get a list of the SMTP email addresses for the current outlook user?

I know how to get the primary email address of the current user, but how can I get a full list of all their SMTP email addresses? I'm looking for the informati

Using a collection to check if Names exist

I am trying to create a subroutine that will take a collection of a bunch of strings, step through it, and check for the existence of a named range or formula t

Loop through filtered criteria only once

The goal of this script is to loop through each criteria filtered in Column C, starting from C8 where my header is located. The information below will be a list

vba how do not count rows (or count only once) if they have the same parameter

I need to count rows in column "rating_status2" with value "unclear" and if they have the same "customer_nbr" only once. How it can be done? The structure of th

is there a way to add a word to a specific column?

The code I'm currently using only allows me to filter then replace certain values. Is there a way for me to filter for lets say column M filter for 0 and replac

Add a hidden tag to outgoing mail

I create a mail by VBA when sending invoices and automated newsletters by Outlook (2019). For reimporting the mails from the Sent folder into the database it wo

Get location of the workbook calling the script

I am trying to execute the following Python script from Excel using Sub MacrosTrigger() RunPython ("import MacrosTrigger") End Sub MacrosTrigger.py conta

Excel code crashes after a couple of uses, opening a connection to Access

We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det

MS Access 2016 decrypt field that is encrypted in linked ODBC SQL Server table

I need to encrypt SSN (nvarchar(25)) field in a SQL Server database table. Once encrypted, the Access program needs to be able to decrypt the field for user vi

It is possible to create a click button in VBA Excel that opens the VBA editor? [duplicate]

I was just wondering: It is possible to create a click button in VBA Excel that opens the VBA editor when the button is clicked? UPDATE: The p

Getting "object variable not set" error when trying to write to new sheet

I am trying to simultaneously read from one sheet and print to another sheet, with additional format. I think my issue has to do with improperly referencing the

how can I get name of current outlook IMAP or POP account with VBA during normal send/receive?

I have Outlook 365. I have multiple POP and IMAP accounts. During Send/Receive, I have a rule-script that needs to know which of the accounts is currently being

Send Outlook Meeting Invitation using Excel

I am looking to send meeting invitations for each row in a worksheet. I am able to create an item that when displayed shows as an appointment, not a meeting re

Copy & Paste Values in Same Location

I am new to macros and am having trouble creating a macro that will copy a range of cells and then paste just the values back into the same cells. Basically I

Restrict only works for some recipients

I have some code to keep my inbox clean. Process: Manually mall mails from outbox to inbox. Now I have all mails to be archived in inbox. Run code. When I had a

Mass Find & Replace including subfolders

I don't really know VBA but have had some success with manipulating code in the past. I'm getting stuck with this one, where I tried to mix 2 different ideas in

How to Search Phone number in Address book?

There are options to get a contact detail from Mail id or Contact's Name using Namespace.CreateRecipient / Recipient.Resolve Is there any option to perform a d

Using VBA in Outlook to Move Emails Containing Name of a Folder

I am looking for some pointers for a VBA code for Outlook. Specifically, run this code to clean up my inbox. We manually create a new folder each time we get a

System Error &H8000FFF (-247418113). Catastrophic failure

I have now twice had this error, where I email a spreadsheet with macros to another person. It is working when I send it using share via email. When they get

Is there any possibility for document paragraph-level tagging and filtering, e.g. by VBA or C#?

The MS Word document has the ability to mark tags at the file level, which can be used from Windows Explorer to make it easier to search for files by document&r