vba

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

Hi All, I'm new here so please bare with me, I run multiple projects with multiple staff needing access to emails currently we just print the emails off and file them in a lever arch file. I'm wanting to create macro to export key details from an email to a project specific email register so...

This macro saves selected emails into a folder chosen by function "BrowseForFolder". It also adds the date as part of the filename. My issue is that the default start folder selected is always the same and I have to navigate to the folder each time. I want to use "msoFileDialogFolderPicker" to...

Working on a desktop and laptop; is there a method to keep the VBAProject.otm files in sync rather than just relying on my poor memory to copy and overwrite!? Peter H

I have a motion sensing security camera in my server room. It sends a mail message with a snapshot any time motion is detected. I'm trying to create a rules script that moves those messages received between the hours of 6am and 6pm to another folder (so I don't have to see them in my inbox...

Hi could someone help? I have a Add-in in Outlook (Newforma) that uses the Application_ItemSend function. You can send an email by clicking on Outlooks Send button or on this Addins button. I wanted to write a small msgbox to remind people to use the Addin when they click on Outlook's Send...

Hi All, The below macro works great and am triggering this when a email arrives. but sometimes i get "Error in rule" and rule stops. Any idea what causing this error ? Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim objAtt As Outlook.Attachment Dim saveFolder As String Dim...

Hi all, I am trying to make a script / rule / combination of both that only occurs when i receive an email from a specific address. I would like to copy the body of the address and edit two things: • there is a hyperlink'ed word, "website" (see attached). I would like to change the address of...

I located a code which creates an email message with a meeting attendee list including acceptance status. I installed the code and was able to run it without issue from both editor and developer tab macro list dropdown. I exported the code to be able to import onto another computer but now the...

Hi All, my first post here, i have this below code working great as it is searching email with subject line and replying to it. the same task can i search by "Attachment name" and make reply ? here is the code Try Dim olApp As Outlook.Application Dim olNs As...

Hi All, I am new here and looking for some support with VBA for outlook. Now i'm faced with a similar task of getting something done with outlook and I was hoping someone can help me out. Here is my situation: I have a team of 15 people that is split into 4 member groups and they all handle...