All Questions
48
questions
1
vote
0
answers
62
views
Outlook rule to move a different email than the one that triggered the rule
I get a series of emails (separate, not in the same conversation) for approvals. The first email will have a subject line "ACTION REQUIRED: [XYZ] approval request." If another user ...
- 11
3
votes
1
answer
664
views
Automatic reply in Outlook when out of office
For my e-mail account on a Microsoft Exchange Server, I would like that, for each email received where the following two condition are met :
I am in the to: or in cc:
I have an "out of office&...
- 31
0
votes
0
answers
2k
views
VBA - paste multiple Excel ranges into Outlook as images
Trying to create an Outlook email that has Excel ranges pasted as jpg in the email, along with text before and after. Something like:
Text
Image 1
Image 2
More Text
However, I cannot figure out how to ...
- 1
0
votes
1
answer
524
views
I need VBA code to select certain rows based on grouping data in one column and email that selection
I need to select rows based on email address and mail it to that address. I only have code that will send a worksheet to email
The image is the sample file. The macro needs to select the rows based on ...
0
votes
0
answers
3k
views
How to make a Search with VBA through all folders and change the links in Outlook?
I stuck with one problem. I have my outlook and I have some folders there with messages. I need to go through all these folders and then replace the links in those messages. Is it possible to do?
I ...
- 13
0
votes
1
answer
247
views
How to use regex to replace text in forwarded email
I have the following code that I pulled from, niton (VBA to forwarding emails in Outlook).
Private Sub objInboxItems_ItemAdd(ByVal item As Object)
Dim objMail As MailItem
Dim objForward As ...
- 1
1
vote
2
answers
1k
views
Outlook Rules Sending Auto-Reply Over Specified Time Range
I am seeking help with Outlook Webmail.
Specifically I am trying to set up auto-reply messages during certain times of the day.
Outlook offers out of office emails, but I am trying to set up rules ...
- 111
1
vote
3
answers
1k
views
Canned auto email forward (with attachments) in Outlook 2013
I get emails sent into me from one sender (with attachments). All I do is forward (not reply) that email to another recipient with a short sentence (always the same).
Surely this could be automated .....
- 201
0
votes
1
answer
4k
views
VBA to forwarding emails in Outlook
I'm trying to create a vba that can forward emails I received. The only problem is that the emails I'd like to forward have different subjects. Only the beginning is the same. This is how far I've ...
0
votes
1
answer
2k
views
Use VBA to send email from a shared Outlook account
I have a simple VBA script to cycle through a list of email addresses in Excel and send email with individual attachments. This works fine, and emails are sent from my primary/default account that is ...
- 1
1
vote
0
answers
56
views
VBA Code Enhancements
I have been using the following macro, which works very well indeed, but it has come to the point where it needs some enhancements:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myMail As ...
- 11
0
votes
1
answer
55
views
Mark email messages received with delay
For many reasons an email message can be hold up in mailservers for several hours or even days.
I wanted to create a rule that assigns a given category to messages received with a delay greater than ...
1
vote
0
answers
236
views
MS Outlook VBA Script - Automatic Print ORIGINAL email when it gets undelivered [closed]
I'm using MS Office 2016 Desktop App on Windows 10 and looking for some functionality which I didn't find any success after searching online a lot and also contacted MS Outlook Support to only find ...
- 111
2
votes
1
answer
1k
views
Outlook run VBA script on email to move to folder based on 6-digit number in subject
Our company uses a 6-digit number for our projects. I'm attempting to create a script that will search the email subject for this 6-digit number, then find the subfolder that starts with this 6-digit ...
- 31
0
votes
0
answers
6k
views
See who last changed category color on outlook email
Here is the situation. Someone at work in a shared inbox keeps changing the category on incoming email to a specific color. For this shared inbox those colors represent the employee who has picked up ...
- 204
1
vote
1
answer
696
views
Auto attach a file to a specifc email template
Every morning i have to update a file with some data and then send it to people and its getting a bit laborious having to attach the same file over and over again each day.
I have a template with the ...
- 11
0
votes
1
answer
4k
views
Outlook VBA Scripting – Print Attachments & Move Emails
I am new to VB scripting so need a lot of help.
A recent change to an email account means emails received are been moved to a folder other than the inbox by a rule that I have not input into and ...
- 3
-1
votes
2
answers
466
views
SyncObjects.Item Method (Outlook), explain [closed]
This link:
https://msdn.microsoft.com/en-us/vba/outlook-vba/articles/syncobjects-item-method-outlook
is devoid of explanations. What is the meaning of SyncObjects.Item(1), for example? Can I have a ...
0
votes
3
answers
8k
views
Running VBA on a shared mailbox Outlook 365
I have this code for saving attachments from e-mails with a specific sender and topic, down to my hard drive. It works fine when it is only working on my personal mailbox. But i need it to work with ...
- 9
4
votes
1
answer
428
views
How to set Outlook to convert email body to file attachments before sending
In our business we do some electronic faxing, where you can send an email to [10-digit-fax-number]@[fax-service-domain], and the service faxes the email attachments (not the body). But it is sometimes ...
- 104
1
vote
0
answers
378
views
How to create a rule or VBA code for Outlook to copy the the messages from specific folder to another folder?
I am looking solution to the following problem:
There is a mailbox for the requests from the customers with 7 clients that filtering the incoming e-mail from general "Inbox" to the different folders ...
1
vote
1
answer
3k
views
What is the VBA syntax to reference a folder in Outlook 2013?
Working on some code to mark items as read when they are moved into my 'Archive' folder which is on the same level as my default folders (Inbox, Sent, etc.). The code below was my initial test using ...
- 220
1
vote
0
answers
67
views
VB to email from Draft folder
Quick question...
Had a a VB "app" in excel that takes an .oft file, adds name to it from VB app in Excel, places in Outlook Draft.
Second piece of code, in Outlook, allows me to send the Draft ...
- 11
-1
votes
3
answers
2k
views
How to save multiple pdf attachments in Outlook to hard drive by extracting mail items
I have 25 mails which each have 25 pdf attachments inside of them within only one email - cascading each other. In other words, one email contains 25 outlook mail items which have 1 pdf attached per ...
- 1
0
votes
1
answer
1k
views
Microsoft Excel - Using VBA to send email with a loop
This code filters an Excel sheet by last name, copies that data into a new workbook, then does a Vlookup on sheet 2 to match the last name with an email, and sends an email to that person. I edited ...
0
votes
1
answer
2k
views
VBA Function to parse email body for email address, write to excel
I have a requirement such that I need a function to iterate through all emails in an Outlook (2010) folder and grab an email address from the body of the email. The emails are found from Inbox \ ...
- 1,130
1
vote
1
answer
2k
views
Excel VBA code and Outlook Programmatic Access warning
Since about last Friday one of my Excel macros that generates an email has been getting this warning:
Microsoft Outlook
A program is trying to access e-mail address information stored in Outlook. If ...
- 715
1
vote
3
answers
4k
views
How to save specific attachment with date stamp from outlook inbox to specific folder?
Every morning I receive an email containing 3 files:
"Daily MILH Checks e.xls"
"Daily Unit Linked .pdf"
"Daily Unit Linked.xls"
That is 2x .xls and a PDF. File names ...
- 111
0
votes
2
answers
53
views
Quickly adding a category to a message
This may sound stupid but solving the problem would save me a lot of time.
I am big on using categories (in place of folders, pretty much like labeling an email under Gmail), and more often than not I ...
0
votes
0
answers
390
views
Automatically (VBA) remove page colour when replying or forwarding email
I am looking to create a macro to remove the page colour from an email when replying to it or forwarding it, either automatically on the single click of a button, instead of having to go to the ...
- 41
2
votes
1
answer
5k
views
VBA Script to Dynamically Change Subject Line on Incoming Emails for Outlook 2013
I have looked at this Outlook script example, which is similar and a great start for me: Outlook Script to edit subject
However, I am in need to change incoming message subject lines on arrival in a ...
- 830
1
vote
1
answer
3k
views
Create an outlook VBA to forward an email with specific words in the subject line
Hello I want to create a rule or a vba in outlook, where the subject line has 3 certain words in any order. For instance, I want to look for "Badges, user, moped"
Subject says: the badges and the ...
- 11
1
vote
1
answer
1k
views
Setting a rule for an incoming mail (read or unread)
I need a little advice on Outlook 2010.
There is this situation:
- one webmail account which is used by a several people (using web browser or phone to access it)
- one computer with MS Outlook 2010 ...
- 11
1
vote
1
answer
1k
views
Outlook 2013 - VBA - reply in line
I have written a small script to automatically select the first autocorrect option. It works when, in 2013, I write a new email or "pop out" an email. However - it does not work when I reply "in line" ...
- 121
0
votes
1
answer
2k
views
How to send email to mailing list in excel using gmail
Currently, when I type an email into excel it becomes a link. When I click on this link, the default browser opens a new gmail tab logged into whichever gmail account I am currently logged into, and ...
- 35
0
votes
1
answer
34
views
Outlook 2007: how to add e-mail in table view to selection without the mouse?
In Microsoft Outlook 2007 I often select multiple e-mail messages in the tabular view (e. g. in the Inbox) to process them with a menu command or macro.
Quite often, this is a selection of multiple ...
- 1,878
0
votes
1
answer
1k
views
Search through an email to find and highlight text
I'm working with Excel trying to automate the sending of some emails. Right now, the code creates an email based on the cells next to the button clicked, forwards the email to the listed in a cell, ...
- 3
0
votes
1
answer
620
views
Outlook - strange item.Attachments error
I have the following code, that should save a specific Excel file attached to an email. The code is combined with a rule, that triggers this script when an email with a specific subject is received.
...
0
votes
1
answer
138
views
run macros assigned to many excel sheets of a workbook, with one click
I have one workbook with 8 worksheets.
I have a macro assigned to each worksheet.
I want to run all 8 macros from one worksheet in one click(by clicking one button, to run all 8 macros).
How can ...
- 103
1
vote
3
answers
6k
views
Line of text is too long in VBA
I'm trying to write a macro to send a canned reply. The issue I'm having is that the body of the text is too long to fit on one line in my code. I have no idea how to have a second paragraph of body ...
user431543
4
votes
2
answers
34k
views
automatically Save outlook attachment
Is there a Windows-based method that can automatically pull save email attachment from a outlook 2010 to a server?
I get aan email daily with an attachment that I manually save to a folder on a server....
- 41
0
votes
1
answer
541
views
Outlook 2010 oft template Item_Send not firing
I have written a very simple Item_Send handler for an outlook mail message template stored as an oft file that I run via a Macro:
Function Item_Send()
MsgBox "hello"
Item_Send = False
End ...
- 233
2
votes
1
answer
3k
views
Outlook macro to remove text and insert signature
(Note: I've never messed with VBA before; sorry for probably terrible code!)
I'm trying to make a macro that first removes paragraphs containing specific terms (hardcoded into the macro), then sets ...
1
vote
0
answers
156
views
Why doesn´t my Outlook rule work more then once?
I´ve recently migrated my email to an exchangeserver, with my previous email set as a forward to my current one.
I´m using outlook 2010 and Samsung galaxy s5.
First problem at hand: Some E-mails ...
- 11
1
vote
1
answer
2k
views
When using multiple accounts, how to ensure emails are sent from the correct account
I use 2 email accounts with Outlook. One for work, one for personal.
The problem I have is I am forever sending work emails from my personal account!
How do I set up a list of "do not send email to ...
- 25.4k
0
votes
1
answer
1k
views
Autoforward Outlook emails to external only under certain circumstances
Is there a modification that can be made to the VBA code provided in this response from an earlier post that would only forward email from a certain email address rather than forwarding everything? ...
- 1
4
votes
1
answer
1k
views
Read mail attached excel files
Is there an easy way to data read excel files that are attached in emails in Outlook? Im sure this is scriptable, but I dont particularly want to write it.
Is there a program out there that can ...
- 73.5k
2
votes
2
answers
6k
views
VBA code to insert custom signature in Outlook 2007 email
I need to insert a specific signature into an email message. Our support team uses a variety of different signatures to respond to different types of support needs. Currently, I access them via the ...
- 21