Outlook 2016 Creating an outlook Macro to select and approve

Status
Not open for further replies.
D

Demonpanda56

Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
Hey I was curious about Macros for Outlook 2016 and
kinda wanted to get a bit more lazy but I have a ton of these emails that come in asking for approvals or rejections and I want to be able to approve the selected emails .

Would this code work for that?


Sub ApproveSelectedEmails()
Dim myFolder As Outlook.Folder
Dim myItem As Object
Dim selectedItems As Selection

Set myFolder = Session.Folders("ETSC - TEST").Folders("Inbox")
Set selectedItems = Application.ActiveExplorer.Selection

For Each myItem In selectedItems
If myItem.Class = olMail Then
If InStr(1, myItem.VotingOptions, "Approve") > 0 Then
myItem.VotingResponse = "Approve"
myItem.Send
End If
Next myItem
End Sub
 
Status
Not open for further replies.
< Want to create a button on the nav bar (module add-in) to run code | VBA no longer working in Outlook >
Similar threads
Thread starter Title Forum Replies Date
F Creating Macro in Outlook 2003 Using Outlook 8
O Macro for creating hyperlinks in Outlook 2007 Using Outlook 3
I Creating an Outlook 2007 macro that attaches a signature to new me Outlook VBA and Custom Forms 1
T Outlook creating unwanted tasks in Tasks and Todo from emails Using Outlook 1
M Creating an RSS Feed **FROM** Outlook 2013 Calendar. Using Outlook 5
R Would creating a new profile cause Outlook to download all the old mails from the server? Using Outlook 1
T Outlook creating a folder named: "Unwanted" Using Outlook 3
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
Liza Creating a rule in outlook to filter messages Using Outlook 0
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
A Creating an outlook rule to forward an email with a specific message Using Outlook 1
N Creating or changing the main new mail message template in Outlook 2010 Using Outlook 2
J Outlook creating unwanted rule on its own Using Outlook 1
Rupert Dragwater creating gmail account in Outlook 2013 Using Outlook 7
J Creating an "isolated" shared calendar in Outlook Outlook VBA and Custom Forms 1
Witzker Outlook bug when creating a user defined contact form? Using Outlook 1
G Creating an Outlook Rule using Internet Header time Using Outlook 1
Wotme Creating a Outlook task in Excel Using Outlook 7
G Questions on creating Outlook forms Using Outlook 0
K Outlook 2010 creating extremely large PST files for IMAP accounts Using Outlook 3
J Troubleshooting Creating New Outlook Account Using Outlook 1
P HTA creating Outlook MeetingItem - need formatted body text Using Outlook 4
A Creating a sign up form in Outlook 2010 Using Outlook 1
N Creating dynamic forms in outlook?? Using Outlook 2
M Outlook 2010 and how to get attachments listed when creating a new email? Using Outlook 1
V Creating Distributions in Outlook Connector Using Outlook.com accounts in Outlook 1
S Outlook 2010 Ribbon - Creating Links To Websites or EXE Files Using Outlook 4
J Creating Tasks in Outlook 2007 with VBA Outlook VBA and Custom Forms 1
U Creating or modifying Outlook .Nk2 file in C# Outlook VBA and Custom Forms 1
C Creating an Outlook Profile for RPC over HTTP client Outlook VBA and Custom Forms 1
J Creating form in Outlook 2007 Outlook VBA and Custom Forms 1
T Outlook 2010 Creating a email 'Group' in OL 2010 Using Outlook 2
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
G Event when creating task from mailitem Outlook VBA and Custom Forms 2
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
R Creating a user defined function Outlook VBA and Custom Forms 3
O How to prevent CC from showing when creating a new mail? Using Outlook 1
N Creating a button or link to a form in the Organizational Forms Library Outlook VBA and Custom Forms 3
B Creating an email with the list of tasks Outlook VBA and Custom Forms 0
L Creating drafts when I thought I was sending Using Outlook 1
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
A Are categories still recommended for creating local distribution lists? Using Outlook 3
S Creating Email - Selecting Pre-Defined Text Using Outlook 2
N Creating New Profile Using Outlook 0
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
M creating email from contact file = 3 emails in To field Using Outlook 3
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2

Similar threads

Back
Top