Excel VBA to move mails for outlook 365 on secondary mail account

Status
Not open for further replies.

Firozyshaikh

Member
Outlook version
Outlook 2016 64 bit
Email Account
Outlook.com (as MS Exchange)
Hi....
I need VBA code to move emails received from specific mail id / specific word in subject to sub folder. But my challenge is i have two email account on outlook 365, 1st is my default mail account and second mail account is not configured locally on my machine (i.e. Outlook app on windows system) but on server (this second mail account is also not seen on my Account setting option) but it can be seen on outlook app on windows and i want to apply rules or VBA code to that secondary server mail account. If i create any rules it only works on my default mail account but not on server mail account, hence I want to use Macro.
The need here is we have a common mail id used by many of my team members (agents) and i need to bifurcate mails to their specific folder as per client mail id assigned under each agent.
Even if rules can't be created, please suggest a macro code to run on outlook or excel and move mails from secondary mail account inbox to subfolder under same secondary mail account as per the inputs given in excel file for.eg. i'll have a column in excel with all agent name which will be also a subfolder name in secondary mail account and will specify all client mail id against that agent name in another column in excel and VBA should move those specific clients emails to specific agent as mentioned in excel file
 
Or Simply I need VBA code which I can run on particular folder on outlook by every end of the day for all emails received by eod. This Code should pick up email id from the excel file which will have client email address / domain name in one column and my team i.e. agent names who handles those client in another column and move respective client email as per their domain name to respective agent folders which will be already created as sub folders under inbox on outlook .
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
S Excel vba code to manage outlook web app Using Outlook 10
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 3
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
S Find a cell value in excel using outlook vba Using Outlook 1
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
P Outlook 2016 from Excel 2016 VBA Using Outlook 1
N VBA Outlook reference to Excel and assigning category Outlook VBA and Custom Forms 13
Z Default VBA code for extracting data from email (Outlook) to Excel? Outlook VBA and Custom Forms 1
D Outlook VBA to open Excel attachment and send recipient's email address to a workbook cell? Using Outlook 4
M using Folders.Count in Excel Vba Outlook VBA and Custom Forms 8
J vba to get email name , subject and attachements on excel list Outlook VBA and Custom Forms 2
S Requried a VBA Code to export Calander details to excel... Outlook VBA and Custom Forms 4
M VBA Send Sales reports using .oft files, originate in Outlook or Excel? Using Outlook 5
B Excel 2010 vba to post appts to different outlook calendars at the same time Using Outlook 6
C Open/Close Outlook - Via Excel VBA Using Outlook 2
S Email Help: Sending Outlook email from Excel VBA Outlook VBA and Custom Forms 6
W Using Excel UserForm from Open Workbook in Outlook VBA Outlook VBA and Custom Forms 5
H add an appointment for a custom calendar, vba excel Outlook VBA and Custom Forms 2
M can't access outlook contacts from excel via VBA Outlook VBA and Custom Forms 4
L Error when exporting Sent Mail to Excel Outlook VBA and Custom Forms 6
P OT: Need website like this one, but for Excel Using Outlook 0
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
W Outlook 365 I am getting the "Either there is no default mail client" error when I try to send an email on excel Office 365 Using Outlook 1
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
D Cannot populate certain UserProperties in Outlook from Excel Outlook VBA and Custom Forms 2
H Information from user defined field into Excel Outlook VBA and Custom Forms 7
N Extract Outlook emails to excel Outlook VBA and Custom Forms 2
M Extract all links from Outlook email, send to Excel Using Outlook 2
C Pull Outlook shared calendars items from Excel Outlook VBA and Custom Forms 4
S How to export urls from email to excel and check the status of the url ? Using Outlook 5
S save email from excel Outlook VBA and Custom Forms 1
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
E Accessing shared outlook folder doesn't work since switch to new outlook/excel Outlook VBA and Custom Forms 11
E Copying the whole e-mail body into excel Outlook VBA and Custom Forms 0
E Copy e-mail body from outlook and insert into excel Outlook VBA and Custom Forms 3
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
K Update Appointment category when changed in Excel Using Outlook 3
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
D Paste Excel table into Outlook message Outlook VBA and Custom Forms 6
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
D Retrieving Tables from outlook to excel Using Outlook 14
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
N Export details to a excel spreadsheet using macros Using Outlook 0
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0

Similar threads

Back
Top