vba

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, I am trying to adapt this code for using the macro only in unread emails in my Inbox, but I don’t get anything that works. Someone for helping me? THanks in advance. Public Sub Unread_eMails() Dim myNameSpace As Outlook.NameSpace Dim myInbox As Outlook.Folder Dim myDestFolder As...

Hi all, Is there a field within an Outlook mailItem which allows you to store an ID number e.g. 123456 which you can read from their reply email? I am trying to insert a contactId somewhere in the email which I can read when the person replies and use to make updates to an Access database. I...

All the reply (RE) and the forward (FWD) mails received in the shared inbox has to automatically move to an "Ongoing folder". Private Sub Application_NewMail() Dim olNameSpace As NameSpace Set olNameSpace = GetNamespace("MAPI") Dim olDestFolder As Folder Set olDestFolder =...

I'm looking for an outlook macro, that sends out auto acknowledgement emails for new mails received to a specific shared inbox. (Should not auto acknowledge for reply and fwd message), and not sure how to exclude the reply and fwd mails. Below code Is not working. Please advise. Public...

Hi, the company I work for sends out meeting requests to everyone when someone is going to be on vacation, as a way of letting people know who's not going to be available. But the meeting requests are set for 8am to 5pm, include the standard 15 minute reminder, and are set to busy, which makes...

This has been asked before, but not answered. In Outlook (and MS Word and WordPerfect), I use styles for everything. Therefore, I want the styles panel to be docked on the right hand side of every edit window in Outlook. I am barely a beginner with VBA, but this seems to be something that VBA...

My Outlook has multiple accounts. How do I get the Items object of a specific account? For example, assume that there are three account, username@abc.com, username@def.com and username@ghi.com. Further, assume that Items object that corresponds to the Inbox for username@ghi.com is needed. What...

Hi, we are publishing Outlook forms (*.oft files) using the following code: olMailItem = _olApp.CreateItemFromTemplate(pathToOftFile, _missing) as MailItem; olFormDescription = olMailItem.FormDescription; olFormDescription.DisplayName = "MyDisplayName"...

Hello, First time poster here, i took some time to read what the forum has to offer but i still have some questions Description of the issue: What i am trying to achieve is that when ever i receive a email with the Subject "XXXX" from the sender "XXXX" it will look in the body for a specific...

Hi everybody, I've just joined this forum - thanks for having me and I need some of your expertise, if you don't mind... My situation: I have a single outlook.com exchange account added to Outlook 2019. By default, when I go into Send/Receive Groups, All Accounts, Edit..., the tickbox for...

Hello, I came across an article named "How to Quickly Export Voting Statistics from an Outlook Email to an Excel Worksheet" and it's almost what I'm looking for. I'd like the macro to actually list the user names and/or email addresses and their responses. I realize I can do this manually but...

I didn't see an option for Office 365 Pro Plus in your list of Outlook version, so chose Outlook 2016 32 bit for lack of knowledge on which would be closest fit. I erroneously placed data in the Computer Network Name which won't export with the CodeTwo Outlook Export tool or the native...

I am familiar with VBA, but most of my VBA experience is with Access. I would like to write VBA Code to collapse or expand all Task folder groups. This works with the tasks themselves using the native option under View - Expand/Collapse; however, it does not expand or collapse the sidebar groups...

Hi, I'm very new to this VBA but have read Open All Hyperlinks in an Outlook Email Message posting. However, I'm looking for a way to open a very specific Hyperlink within an email usually following the word "Attachments" the name of the Hyberlinks differ each time. Or perhaps another way to go...

With Outlook 2016 in VBA I try to save an email as a file. I get the error message: Outlook could not complete the saving due to an error with the permission for the file …… .. I tried to change the permission for the folder where I want to save the file. Anyone can write in this folder. But...

Hi all: My organization has started prepending "[EXTERNAL EMAIL]" to subject lines. Some of the people I correspond with are frustrated by this, especially when replies end up with multiple copies of that string. My goal is to remove that text (at least for certain people). Using (very...

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...

Hello, I am reasonably experienced in using VBA for Excel, but new in Outlook. I copied some basic inbox new mail trigger code that should work. However, I get an "invalid or unqualified reference" refering to "item". Can someone please give me a pointer as to where to look. I have googled for a...

Hi there, Since 2010, my workflow is based on the principle of Control Your Day. Main tools are categories and search folders. I have improved the process by adding my own VBAs to add next actions to the context folder. The last missing piece I can not get working is the ability to create a...