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

Firozyshaikh

New 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
 

Firozyshaikh

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Outlook.com (as MS Exchange)
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 .
 
Similar threads
Thread starter Title Forum Replies Date
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
D Cannot populate certain UserProperties in Outlook from Excel Outlook VBA and Custom Forms 1
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 ? New Slipstick.com Articles 6
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
T Outlook Calendar 2016 import Excel Using Outlook 1
D Macro sending outlook template from Excel list Outlook VBA and Custom Forms 6
N Lookup Value From Excel and Reply With Matching Value Using Outlook 0
D send email from Excel using outlook template Outlook VBA and Custom Forms 3
Diane Poremsky Importing Lists from Excel to Outlook New Slipstick.com Articles 0
N Paste content to Excel when .txt file (attachment) is opened Outlook VBA and Custom Forms 1
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11

Similar threads

Top