vba

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

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

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

So we know Outlook has this internal filtering system that sends junk mail to Junk folder even when filtering option is turned off. I'm wondering if there's a way to look at or "hack" it. Using VBA or something? I want to keep some emails from being labeled as Phishing or junk by the internal...

Hi, I'm new to VBA and also this forum. I'm using a simple script code to save email attachments to a Drive folder and name them when they arrive, and activating it within an Outlook rule(run a script), its working fine.......when there is only one attachment in the email. Is there a script...

I would love to be able to automate a time consuming, tedious process that a couple of us are faced with in the office. We receive around 130 emails 6x a year with no way to easily identify the school the email is about. There is a string within the body that looks like this - S987654.X# (the X...

I am not a VBA programmer. The following is the main sub of a project that I cobbled together for Outlook 2007 and was pleased to find it worked for Outlook 2010 a few years later. However, we are moving to Outlook 2016 now and I've found that it does not work as intended. We have displays...

Hi All, Sorry in advance if this question has been asked already, I just can't seem to find anything online that I can understand. My experience with VBA is limited to its applications with excel. Everyday, I receive hundreds of emails from variable external persons. I would like to assigned...

Hi All, Sorry in advance if this question has been asked already, I just can't seem to find anything online that I can understand. My experience with VBA is limited to its applications with excel. At the moment, every time I save my spreadsheet at work, it will automatically send that saved...

Most of my tasks are done via Outlook ie most of the work I do is composing and responding to emails. I can switch Outlook offline /online manually, but I was wondering if there was a Macro that would automate this. My schedule is as follows 7am Online 8:45 Offline 10:45 Online 10:50 Offline...

Hi, I am looking for a VBA code to forward emails from a common mialbox to another address based off of two constraints: 1. if the email came from a certain address 2. if the email came between certain times Thanks for your help :) Coffee

This macro saves selected emails into a folder chosen by function "BrowseForFolder". If I select "n" emails to save, the dialog comes up "n" times. Is there a way to call it up just once? Option Explicit Public Sub Save_Messages_Select_Ask2() Dim oMail As Outlook.MailItem Dim objItem As...

Hello all, I am trying to convert a pivot table to a functional csv file. This is what I have so far but keep getting error messages. Any suggestions would be so very appreciated. Thanks! Alexa sub Export_To_Excel_View1 Dim xlApp Dim xlBook Dim xlSheet Set xlApp =...

Hi, I'm new to this, and googled everything I possibly could, but was unable to find what I need. I'm getting too many spams, so had an idea of how to minimize the problem, but have no idea if a code for this already exists or if anybody could help me build a VBA code. The idea is to setup a...

Hello everyone, I am trying to change some rules in outlook, as I have more than 300 rules and would like to change the routing for a given email to a group depending on the name of the rule. I tried to make an adaptation in the code of the list of rules and Sort Rules, but still I could not...

Please help me create a script that will help me save A LOT of time. I need an auto forward that will include the attachment, all to the SAME EMAIL, but I need to change the subject based on who I received the email from(up to 5 different ones). Maybe an IF statement or WHILE loop? Any help...

Hello, Wondering if someone can help me. I have created this Macro to reply to emails with a template. It works great until I try and reply to a meeting invite. I get a type mismatch error and I am thinking that it may be that these are .ics items and that's causing the issue. Any help would be...

Hi everyone, Very new to VBA. I write similar emails everyday to the same email address. I needed some help to automate it using VBA macros. Basically, I want: To: xyz@xyz.com Subject: 'TEXT' & todays date & the sent email counter(if possible) Body: Clipboard item Send Can somebody please...

Hi all, I have a macro at the minute which i have found and changed to suit my needs which saves an email in a file location on my server at work. I have just found another macro which inputs details from an email message into an excel spreadsheet. i was wondering if anyone would be able to help...

Hello, I am not very familiar with VBA but was trying to find a "simple" way to automatically perform the following: I want any message that I receive, that was sent to a specified group from the address book, to save to a shared folder (that I have access to); and add the date before the...