vba outlook

Hi! I have written a VBA script that counts the number of words in the e-mail body and adds the word count to the subject. The problem is that this fires for all e-mails: Replies, Reply All, Forward and New. I would like this to fire ONLY for new e-mails. Thanks

Hi, I'm using a code to hide Deleted items folder which let me hide any selected folder even if it's in a delegate mailbox but to make the folder visible again since I cannot select it I have to use Session.GetDefaultFolder(3) where number 3 represent the Deleted items folder (OIDefaultFolders)...

My company has a list of "Trusted" domains that we are allowed to open links and attachments when we receive emails from these domains. If the email comes from outside our company, it is automatically get a highlighted phrase added to the body of the email to let us know it is from an outside...

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 have a number of messages stored on an external drive in different directories. I would like to script to import say directory "ABC" into Public folder "ABC" in Outlook. Manual drag and drop would take forever. I am hoping someone has encountered this situation before and can share their...

Hi, I have a VBA script that auto-forwards one set of conditions to a group of people. I want to add another set of conditions so that it auto-forwards a different email to another group of people so that the script sends email 1 to group A and email 2 to group B. I'm having difficulty getting...

Hi, I am new to the new forum and trying to help some help in importing emails from outlook into excel based on email body filter. My search string contains "dot" in between and that seems to be creating issue. The number 29 in search string needs to be a variable number which will be picked up...

I created VBA code to automate the formatting and language selection in new e-mail messages and replies to e-mails, because I send a lot of e-mail and in different languages. One irritating issue which I cannot resolve is the spell check that is performed on the e-mail subject. My default...

Hello, My Outlook VBA code causes a UserForm to pop up at specified times during the day (triggered by the reminders). When it does, the user needs to take action or may close it, depending on the information displayed on that UserForm. I need to have the possibility to navigate through...

Hello ! I am trying to "merge" the Automatic insert receptens name and replyall with template macro.. What am i doing wrong ?? Im trying to merge theese 2. They work seperately. But after adding the autoinsert names to field the Replyall macro with template wont add the item. GOAL: Is that...

Hello, I'm trying Check the available stores in my Inbox but stopped in "Next oStore" and I receive this error: Run-time error -941162370 (c7e7007e) Automation Error. Sub Test() Dim myNameSpace As Outlook.NameSpace Dim oStore As Outlook.Store Set myNameSpace =...

Hello, friends. I'm trying to adapt this code for using in a different Mail Inbox named "Workgroup", but I don't get it. I don't know if a need replace entire main "My Inbox" or create a route from there. In any case, I don't get it! In adiccion, I'm trying to categorize my eMails with a blue...

I currently have a VBA scrip that is running in Outlook where it pops up a listbox. The user selects the attachment, then it is added to the current email and unloads the user form. Now we are wondering if we can do multi-select and choose multiple attachments to go to the email. Here is the...

My company uses an ERP system that emails our customers their invoices as attachments. For whatever reason, these emails from the ERP system are not delivered to Gmail or Yahoo email accounts, but we have included ourselves as recipients and get it without issue. From there we can Reply All...

Hi all, Apologies, but there may be two parts to this question.. In Outlook 2010, I cobbled together a macro from a series of code snippets and some of my own volition, and everything "works" (subjective term). Basically the macro constructs a calendar and adds appointments from a group of...

Hi Diane, I'm trying to add use a macro that when pressed via a button on the ribbon will add a category to the new/outgoing email. If I start a new email the macro works fine to add the category but as soon as I hit send it seems to be removed and it goes without the category on. The reason...

is this possible? Is there a way to use a macro that will search an inbox for a part of a subject line from an email then forward the search results to another email? Example: Macro is triggered, for each COMPLETE email in the inbox, subject line of the email is “This is the subject COMPLETE”...

we have a Document Management System that when an email is sent or received and is filed it gets given a Message class that contains EMS, I want a code that will create a search folder that will search "Sent Items" for a message class that contains EMS? Thanks in advance

Hello, The folowing code worked OK in 2013: Private Sub attachementTool() Dim msg, Dim attach Set msg = Application.CreateItem(0) msg.To = "me@gmail.com" msg.Subject = "test link" msg.HTMLBody = "<html><body>click <a href=""cid:attachCid1"">here</a> to open attachment <br />" & _ "click <a...

Hi, I have a simple VBA code in Outlook 2016 that pops up when users send an email that does not contain our domain name. This works fine on a local machine using a local profile but when I transfer the code to accounts in a Citrix environment the code works only once and then disappears and...