vba

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. S

    Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook

    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 =...
  11. S

    Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox

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

    vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply

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

    VBA code to dock Styles whenever I write or edit an email

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

    How to get the Items object of the default mailbox of a specific account in a multiple account Outlook?

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

    CreateItemFromTemplate throws OutOfMemoryException

    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"...
  16. O

    Forward a email with modified body Automatically.

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

    Email not leaving Outbox when using Excel VBA to sync Outlook account

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

    How to export Voting Results with user names and their responses

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

    Copy Outlook contact field value to another field

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

    VBA to Collapse Task Folder Groups

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