vba

I often use the "send on behalf of" feature in Outlook 365. But I wish the email to always cc the account on which I'm sending on behalf. Here is what I do today: > click to send a new email from my account: e.g. me@mydomain.com > Click on the FROM button and in the drop-down, click on OTHER...

I have the following in the ThisOutlookSession module: Private Sub Application_Startup() Application.ActiveExplorer.WindowState = olMaximized Application.ActiveExplorer.ShowPane olFolderList, True Application.ActiveExplorer.ShowPane olOutlookBar, False Application.ActiveExplorer.ShowPane...

Hello, I'm writing a VBA macro in Excel where I need to open an Excel file saved in an Outlook folder, make some modification and then save it. Here's the last part of my code: ... Set myFolder = myFolder.Folders("XXX XXX") Dim myItem As Object Set myItem = myFolder.Items("YYYYY.xlsx") Could...

I have a .pst file named 2007 I am trying to find a vba code to organize that file (2007.pst) and take emails in that file (2007.pst) and create new folders and move said email in that file (2007.pst) by sender's name. Can someone please help?

Need a VBA to bulk move File As to First Name... anyone have something I can use .....

I have 3 QuickBooks files for 3 different companies, we are sending the sales orders and invoices from the same outlook application, I have 3 email accounts where I'm sending the emails from, each account is being used for a different company, I've developed a macro to detect which email account...

I have recently added a number of Macros to my Outlook (Classic) (Ver. 2408 Build 17928) and now every time I exit Outlook it prompting to save the vbaProject even though I have already saved it. Is there an Auto_Close macro that can be set to save Outlook Project with the prompt? I have tried...

Hi everyone, I am facing a technical issue with a custom form in Outlook for Microsoft 365. When I draft an email using this custom form and save it, it doesn't show up in the Drafts folder on my desktop Outlook; but it appears in the Drafts folder in the web version of Outlook.🤔 Below are the...

Hi there, Not sure if this is a question that's been asked before, but I couldn't find an exact answer for what I am looking for. We use a platform that can send us email alerts when a customer's water consumption has reached a certain threshold. So e.g the customer uses 4500L of water by...

The code I was able to geto from Diana's Slipstick Forum Print a list of your Outlook folders and slightly amended to be able to get datetime properpies of the Outlook folder. The output generated in the MS Outlook nested folder is fine, but it does not work with PST folders, the output...

I'm having some serious issues with my Outlook Rules that no one in my IT Dept seems to be able to fix. Seems like an Exchange issue. I receive upwards of 2,500 emails every day, with about 200 pertaining to my own clients. And so I'd like a VBA script to identify the emails I want and send the...

I was using this code a while ago, I'm not sure if it was from this forum. It can do: (1) Jump to folder But also would like it to do: (2) Select message that you searched for Reason is that there can be a lot of emails in a folder. Option Explicit Public Sub get_folder_path() Dim...

Hi all, On olkexplorer.officeUI (Outlook for Microsoft 365 MSO) I have manually added a dropdown with several items followed by several buttons. <mso:dropDown id="MydropDown" label="SOLV Tickets" enabled="true" getItemCount="Project1.DDItemCount"...

So after a bit of research I've come to the conclusion that Outlook has a sort of built-in protection that prevents automatically forwarding mails that come with a "FW:" or "RE:" in the title. Probably to prevent mail storms or something. Is there a way to disable this security feature? I...

Hi all, When I receive new email, I need to copy email body text that is between specific two words, like copy text from Hello work to Kind regards word. Email body also, most of the times, contains table. Can someone help me with this? Thank you in advance!

I sent emails very often with images/screenshots where I want to mark something with a shape or arrow. The default rectangle shape of outlook is like this: I would like to have a macro, assigned to keyboard shortcut, that formats the shape to something near this (provided that shape is...

I am working on a private Outlook project where I can read all emails from a specific account, starting in a specific folder, looking only in a specific folder, from a specific date etc. Usually the default start folder is the InBox (in Dutch Postvak IN). To start there I would use the...

Hi, i have embedded this macro : Public Sub SetCustomFlag() Dim objMsg As Object Set objMsg = GetCurrentItem() With objMsg ' due this week flag .MarkAsTask olMarkThisWeek ' sets a specific due date .TaskDueDate = Now + 3 .FlagRequest = "Call " & objMsg.SenderName...

I want to create VBA that will: iterate through the OneNoteURL UDF, replacing any occurrence of "%20" with a space execute on task creation, or for selected Outlook tasks I've created 3x UDF's that I've created as formula, from the "Field Chooser". These 3x fields are populated by parsing the...

I'm using Outlook 2016. I've tried to do this using a Search Folder. I've used "Tracking Status not equal to Replied" as the primary query item. This finds emails that I have not replied to, not emails I have sent that others have not replied to. Similarly, here is a VBA solution (How to...