vba

  1. Y

    Open and Save Hyperlink Files in multiple emails

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

    error with the permission for the file

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

    Edit subject - and change conversationTopic - using VBA and redemption

    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...
  4. 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...
  5. Alex Cotton

    "invalid or unqualified reference" on code that should work

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

    Outlook macro to create search folder with mail categories as criteria

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

    extract users of a particular department

    HI, In my outlook there are 15k of email address (users) are there. and those users are pertaining to different departments. I'm trying to retrieve users those who are belongs to a particular department say "Civil Engineering" to a listbox using vba. Thanks, Vinoth
  8. B

    Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA

    I am needing to get the email address that someone sent an email TO. I have come up with one method that seems to use a link but that link is no longer valid: Const PR_SMTP_ADDRESS As String ="https://schemas.microsoft.com/mapi/proptag/0x39FE001E" But I cannot find another way. My immediate...
  9. D

    [TOOL] QuickModules to sort emails very quickly to multiple folders

    Hello all ;) , I did not find a way to include it in resources so I'm posting it here. This is a project (VBA Outlook) that I've made that really helped me sorting my emails with Outlook when I was managing projects and had many emails coming on various topic I had to follow. Email rules...
  10. M

    Macro to add date/time stamp to subject

    Hi all, A complete Outlook macro newbie here (and a macro newbie in general). I have been trying to get a macro to work to add a date/time stamp to the subject of all emails in the selected outlook folder. I am receiving an error on my 'check' line to avoid duplication of the date/time stamp on...
  11. D

    Autosave Attachment and Rename

    I have the following code that autosaves the attachments from any incoming mail and renames the attachment with the date and time so as not to overwrite. Public Sub AutoSaveAttachment(itm As Outlook.MailItem) Dim objAtt As Outlook.Attachment Dim saveFolder As String Dim dateFormat...
  12. D

    Moving Emails Based on Recipient/Sender

    Greetings, I have what seems like should be an easy challenge but the simplistic "Outlook Rules" are not getting me all the way to my solution. I was hoping folks here could maybe help. I need to separate emails that are both from and to internal company people from emails that include...
  13. D

    Move Emails between Folders in Separate Mailbox

    Greetings, I am trying to move all messages in one subfolder to another. Actually I have to do that twice but I can adapt the code myself. My trouble is that I'm far more adept with Access VBA than Outlook VBA. Also, the message folders (current and target) aren't within my own mailbox...
  14. K

    Update Appointment category when changed in Excel

    I have a task tracking list in an Excel table. I have a macro (attached to a userform CommandButton) that, after I fill out the form, it adds the data to the last row of the table and then creates meeting invites based on the due date and time on each row. To avoid duplication of appointments...
  15. D

    Edit Subject (Multiple Accounts)

    On my work PC I have two outlook accounts, my account and a shared account. All external emails that we receive have an annoying note added to the subject line which is basically a warning that it's an external email. I used to have a script set up with a rule but for some reason the 'run a...
  16. A

    Capturing Send Variables without using Application_ItemSend in ThisOutlookSession

    Hello, I want to place a custom button in the send window's ribbon which allows me to capture the sender, recipient, subject, body and date/time sent and pass these through to an Access database then send the email as normal. I have found out how to get these variables using the...
  17. J

    Open an outlook email by Subject on MS Access linked table with VBA

    Hi everyone I linked my Inbox folder to MS access table. It means that every time I open my access table, it is updated as per current emails in my inbox - It is already an built in feature on MS Access. I would like to know on how from my MS Access, using the Subject field in my linked table I...
  18. C

    How to replace or delete first instance of sentence in mail body?

    Dear Madam, Sub :- How to replace or delete first instance of sentence in mail body? hello & have a good day.. I already have a Excel Vba macro for send unique mails for each file in one folder with conditional To, Subject & body with rich text format signature that's work fine ..but .. I...
  19. E

    Search for folder by key in subject then move new message to related folder

    I need to move the incoming message to the related folder if there is a loop for that depending on a key in the subject of the message. I developed a script for getting the key in the subject of new message. How can I search rest of messages by a key and retrieve related folder? Sub...
  20. P

    Run Time Error 91 when linking contact to task in VBA

    I have a piece of code that creates a task then links a specified contact to the task. It worked fine in Outlook 2010, however I have recently updated to the most current version of Outlook (Office 365 version 1708) and the Links.Add method is now throwing the run time error 91 with the "object...
Top