vba

  1. L

    Getting Index from dropdown inserted on ribbon

    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"...
  2. A

    Forward mails with "FW:" or "RE:" in title

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

    Copy specific email body text

    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!
  4. E

    Default shape via VBA

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

    Outlook VBA change GetDefaultFolder dynamically

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

    How to set a flag to follow up using VBA - for addressee in TO field

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

    Outlook 365 Populate Outlook Task UDFs from a UDF text string

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

    How to find emails that I sent that have not received a reply?

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

    Create advanced search (email) via VBA with LONG QUERY (>1024 char)

    Hi, creating an advanced search via VBA can be done easily. But the search query is limited to 1024 characters. I would like to search for emails from/to a longer list of people (from a contact group). The two straight forward ways (which I could think of) don't work: create an advanced...
  10. D

    Advanced e-Mail search on from/to contact group only searches for first 20 contacts in group

    Hi, don't you organize your contacts in contact groups, too? And wouldn't you want to have an option to search for all emails sent to/from contacts in that list? There is an option to do so in advanced search (I didn't find this in query builder or manual filter setup, only on first choice...
  11. J

    Read Outlook Form fields

    I'm only now realizing how in over my head I am with this project I'm working on, bear with me through any faux-pas or misunderstandings, my lexicon is rather new yet. The problem: I've got an Excel file loaded up with data as a scheduling tool for the agency I work for. Its purpose is to send...
  12. J

    WshShell.Popup does't timeout

    ISSUE The popup message box (object.Popup) does not time out and close after 2 seconds in Outlook. Outlook VbaProject.OTM has no other code except that listed below. It works in Excel, Word, Access, PowerPoint and Publisher. QUESTIONS Can it be made to work? Why does it work in other MS Office...
  13. G

    Schedule recurring email and attachments display

    Hi all, I'm hoping someone can help me. I'd like to set up a recurring email within Outlook. I've been told that you can't schedule an email to send but I've been given a code to convert a calendar invite into an email (as its a calendar invite I can schedule it to send when I want) The only...
  14. BartH

    Add a string to the conditions in .Conditions.BodyOrSubject.Text

    I use multiple rules that use conditions like BodyOrSubject holds "string1; string2 etc" I can manually add a string to the BodyOrSubject conditions, but now want to do that with VBA. The code below runs fine until "oRule.Conditions.BodyOrSubject.Add strSubject" - what would be the correct...
  15. S

    HTML to Plain Text Macro - Help

    Good Morning, I am using a macro that converts selected HTML emails into Plain Text, then prints them out. The macro works perfectly. I was wondering how i would add some code that would format the selected HTML email to the 'No Spacing' style before converting it into Plain Text. Condensing...
  16. H

    Search Email Header for Content Type

    Hello All, m facing a huge challenge with RTF Emails and need to find a way to find alle RTF mails inside a mailbox. As a little background: We are using a transparent encryption with Exchange Online. Anything leaving our Office will be encrypted. Microsoft therefore cant read any of our...
  17. D

    auto forward base on email address in body email

    Hello All, Kindly sorry if my English very bad, I'm from Indonesian and i want ask about auto forward with some rules. Example: 1. I get email from Microsoft alert (Office365Alerts@microsoft.com) with body email like this: "Severity: High Activity: FileDeleted User: user@example.com This...
  18. D

    Spell check

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

    Macro for Loop through outlook unread emails

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

    Is there an ID field you can use to pair a reply to the sent email?

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