vba code

  1. S

    Activities in Outlook

    As most on this forum probably agree, it was a sad day when MS removed the activities tab. I recently can across this VBA code to create an activates search, run running it I get an error, see below in red. Is this repairable, made to work for o365? I will also attempt to get Search for All...
  2. Z

    VBA Forward vs manual forward

    Hi all, I am trying to find position of certain words in email body (Hi, Hello, Good morning, Kind regards). For 70% of received emails it works fine, but for some emails it does not recognize these words. If I manually forward email to me and then do a search, it finds them, but if I forward...
  3. A

    Any way to force sort by/group by on search results with VBA?

    Is there any VBA code that will take the current Outlook search results and apply a "sort" and/or "group by" on those results? When search results span many folders, it takes several steps to add the "folder" field back into the results and then "group by" that field. Is there some way to...
  4. S

    HTML Code Embedded in String Within Open Outlook Email Preventing Replace(Application.ActiveInspector.CurrentItem.HTMLBody From Working

    Hi Everyone, I'm trying to develop, what I thought would be, a really simple piece of VBA code to search and replace a string of text in the current, open email. On my first attempt, I discovered that the formatting of the area of the message where I was making the change was being completely...
  5. S

    Auto forward for multiple emails

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

    Respond to Outlook Email

    Using VBA within Access, I'm trying to reply to an email with a template. The code follows and it creates and displays the email that I want. However, it doesn't show the SEND button on the email. The subroutine performs a .display to show the email. Do I need to use a different command? '...
  7. S

    Problem Checking the available stores in my Inbox (Outlook VBA)

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

    Outlook VBA How to adapt this code for using in a different Mail Inbox

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

    The Outlook API wrongfully shows an outlook folder to have zero sub-folders

    Hello, I have a random issue where moving a MailItem to a sub-folder (uner the same Exchange Store) FAILS from time to time. The real issue is that Outlook stops "seeing" sub-folders under the "\\ACME\DefaultInbox\". * It basicaly shows the "DefaultInbox" sub-folder to have "zero"...
  10. S

    Outlook Macro to move reply mail based on the key word in the subjectline

    Hi, I'm looking for an outlook macro that moves mails to when replied to a specific folder based on the key in the Subject Line. Whenever I reply from the "In Progress Folder" I will add a keyword to the Subject line. if the I add Completed in the Subject line that mail has to move to...
  11. 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...
  12. Q

    Prompt button to auto turn on Out of Office

    Hi, I have been working on some VBA to allow me to just click a yes button to turn on my Out of Office when I quit outlook but I can't get it to work. I'm on Office 365. Code is as follows: Private Sub Application_Quit() Dim objMAPISession As Object Set objReminders = Nothing If...
  13. M

    VBA to auto forward message with new subject and body text

    I know this gets asked a lot but none of the solutions I have found seem to be working for me. I am trying to auto forward an email from a specific sender and with a specific subject to a list of new recipients. I'm also trying to change the subject and body of the email when forwarding. I have...
  14. A

    Custom VBA to sort emails into folders

    Hey there... am new here :) I am trying to make a VBA which can automatically download emails (and their attachments) to certain folders based on a word or code mentioned in the email. For example, I have a folder on my harddrive located at "C:\Uni-Work-2019\2259\Emails", and receive a lot of...
  15. A

    VBA Code in Outlook disappears after first use

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

    Selecting a folder from an entry in a Listbox

    I have a large number of folders in my inbox and also multiple levels of folders. I have written a macro to prompt for a snippet of text then return all folder paths containing that text. This works fine and produces a nice list. However, I then have to fumble around trying to locate the...
  17. Z

    Adding dropdown list using custom form

    I'm trying to add project codes dropdown at custom form. Once user selected the project codes, it will display it at the end of the subject. This is the code that I have right now. Everthing working fine untill when I received the sent email. The email wont automatically open like normal...
  18. W

    Save and rename outlook email attachments to include domain name & date received

    Hi all, I'm not a developer and quite the beginner. I work for my family on a farm and we have a heap of invoices coming in each month via email and I'd love to be able to create a macro that allows all attachments that are invoices or statements to be saved to a file on my computer. I have a...
  19. E

    Copying data from e-mail attachement to EXCEL file via macro

    Hello, everyday I get several e-mails with either an excel or PDF file attached that has the following body: Code: 1000 Date Company Currency Amount text 11.11.2018 AAA Dollar 1000 bla 11.11.2018 BBB Dollar 1000...
  20. D

    How to handle filing of emails from an Inbox Subfolder to a specific Public folder

    Environment is Office 365/Outlook 2016: My client has recently noticed that when they go to manually move multiple emails from their Outlook inbox to a "project specific" Public Folder it hangs Outlook until the move process is completed. The more emails they select to move, the longer the user...
Back
Top