vba outlook

  1. H

    Copying email address(es) in body of email and pasting in To field

    Hello all! Long time lurker and appreciate all the help and tips I've been able to pick up. I am looking for a way to copy an email address in the body of an open email and pasting it into the To field. Can this be done? I am currently copying a full page from a word document and pasting it...
  2. L

    Help: set flag for sent mail to check if received an answer

    Hi, I could really use some help here! I have never used VBA - but I sent a large number of emails every day and would need a way to quickly check which ones have received an answer. It would be very similar to this post, but I am struggling to find out how to modify the script...
  3. sjmo2

    Change subject for new e-mails only.

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

    Tweak vba so it can target another mailbox

    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)...
  5. L

    Checking Sender Email Address for trusted domain from list on intranet

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

    How to import many msg into different public folders in Outlook

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

    vba outlook search string with special characters

    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...
  10. 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...
  11. A

    How to stop user form from disapearing once mail window is closed?

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

    Replyall macro with template and auto insert receptens

    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...
  13. 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 =...
  14. 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...
  15. O

    VBA Cases with Listbox - Can you use Multi-Select?

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

    Macro/VBA to Reply All, with the original attachments

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

    macro runs slower on startup than after

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

    Assign categories to outgoing emails

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

    Outlook macro to automate search and forward process

    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”...
  20. S

    Create A Search Folder That Looks For Message Class?

    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