Get Latest De

Excel Vba Microsoft Outlook Mastery And Automation




Microsoft windows Server Software Training


Graduates and Technology Aspirants


Online and Classroom Sessions


Week Days and Week Ends

Duration :

60 Days

Microsoft windows Server What will you learn?

•Learn How To Use Microsoft windows Server.
•Explore different tools used for the Microsoft windows Server.
•You will know how to work with Microsoft windows Server.
•How to connect to multiple data sources with Microsoft windows Server.
•Learn how to design and create a Microsoft windows Server app
•Microsoft windows Server – Learn how to set up your Microsoft windows Server script.
•Learn the fundamentals of Microsoft windows Server and get trained on analyzing data
•Build a strong knowledge base on Microsoft windows Server from Scratch to Advanced level
•This course is designed for any graduates as well as Software Professionals who are willing to learn Microsoft windows Server.

excel vba microsoft outlook mastery and automation Course Features

•Get job-ready for an in-demand career
•Get Training from Certified Professionals
•Job Placement Assistance with Good Companies
•We Provide the Course Certificate of completion
•Assignments and test to ensure concept absorption.
•Project manager can be assigned to track candidates’ performance
•Make aware of code competence in building extensive range of applications using Python
•The course is all about familiarizing the trainees with simpler and smarter ways to develop the skills required for Implementation.

Who are eligible for Microsoft windows Server

•Architect, Lead, Developer, Project Manager, Verification Engineer, Rtl Design, Physical Design, L3 Support Engineer, Cloud Computing, Big Data Engineer
•Developers, Architect, Business Analyst, Analytics, Core Java, Android, Android Sdk, Javascript, Front End, Angular Js, Html, Css, Software Engineering
•Microsoft Azure, Azure, Sql Azure, Cloud Computing, Cloud Testing, SQL, Cognos Framework Manager, Query Studio, Oracle, Business Objects, Issue Resolution
•PHP, MySQL JQuery, Application Developer, Net, .Net, Asp, Vb, Visual Basic, Vb Script, ASP.Net MVC, WCF, C#, SQL Server, .NET Framework, JQuery, XML, OOP
•SQL Developer, Oracle Developer, Tibco, Datawarehousing, Automation Testing, Websphere Admin, Weblogic Support, Python, Netezza, Actuate, Hadoop


•Introduction and Course Download Files
•The Outlook Application Object
•CreateItem Method and Item Types
•BONUS – Troubleshooting Horribly Slow Code
•Creating A New Email With CreateItem Method
•Early vs Late Binding
•Early vs Late Binding – Really Good Article
•Set Up Your Own Constants To Soften Late Binding Blow
•Our First Batch of Constants (For Your Convenience)
•Conditional Constants To Streamline Declarations
•Outlook Namespaces and How To Access Them
•Sending An Email!
•Creating A New Email Using GetDefaultFolder() [Late Binding]
•olDefaultFolders enumeration List
•Adding Recipients (Method 1)
•Adding CC, BCC and Using With-End With (Method 1)
•Set Importance, Read Receipt and Delivery Receipt Statuses
•Add Subject & Body and Popup for Review!
•Save Email as Draft Instead of Sending Right Away…
•Tell Outlook To Send Email Later (Deferred Delivery)
•Create a Quick Burner Email For Testing
•Sending Our First Email Automatically
•Stop Outlook Warnings That Halt Emails Being Sent
•Send Using Alternate Sender Name
•Better Method To Send With Alternate Account (Non-Primary Account)
•Fun Email Tricks
•Sending HTML Email And Easy Customization
•Customize HTML With Outlook Trick
•Free HTML Editor To Make Cool Looking Email Elements
•Dealing With Large HTML Body
•Dealing With Large HTML (Method 2 TXT File)
•Adding A Simple Signature to Email
•Adding The Default Signature to Email
•Using A Different Signature
•Accessing Outlook Folders by Name
•Looping Through Items (Emails) In A Folder
•Finding Specific Item With Find Method
•Filtering Multiple Results Using Restrict Method
•Does Outlook Folder Exist and Adding New Folders
•Finding An Item By It’s Unique Entry Identifier
•Setting Default Inbox Folder For Loops
•Search Emails Dynamically For Past Week or Last 30 Days
•Advanced Filtering Using DASL Queries – Pt 1
•Advanced Filtering Using DASL Queries – Pt 2 – Special Operators
•Testing It Out And Determining If Instant Search Is Enabled
•Easy Way To Instantly Discover DASL Syntax For Complicated Queries
•DASL Reference Materials
•Attachments & Personalized Emails With Excel Data
•Open An Email Template File
•Intro To Customizing with Auto Find and Replace
•Sending A Custom Email to A Specific Row On Worksheet
•Creating A Clickable ‘Send Email’ Column
•Looping Through Excel Data With Customized Emails Pt 1 (Name Filter)
•Looping Through Excel Data With Customized Emails Pt 2 (Date Filter)
•Getting User Input and Assigning Buttons!
•Custom Function To Validate Email Addresses
•Converting A Range To HTML and Placing In Email
•Embedding A Range In Email Body Via Copy-Paste
•Adding A Simple Attachment From File Path
•Embedding An Image In Email Body
•Custom Function For Random File Name
•Attaching Worksheet To Email As PDF
•Attaching A Single Sheet To Email
•Attaching Entire Workbook To Email
•Save Email Attachments To Specific Folder If It Doesn’t Already Exist
•Open Email Attachments And Gather Info Into Current Workbook!
•Calendar Manipulation & Appointments
•Calendar Items, Appointments and Meetings
•Adding A New Appointment
•Adding A New Meeting With Multiple Attendees (Recipients Method 2)
•Duration Versus End Time!
•DateAdd Function: Fun With Dates!
•Determining Schedule Conflicts With Simple Math
•Check If Proposed New Entry Has Schedule Conflicts with Restrict
•Custom Reminders, Sound Files, Minutes Before Start, etc
•Change Meetings With Bob To Red
•Outlook Tasks
•A Brief Overview of Outlook Tasks
•Create A New Task
•Assigning A Task To Someone
•Looping Through Existing Tasks
•Sending A Status Report For A TaskItem
•Calculate Overdue Tasks; Auto-Email or Mark Complete Based on Task Ownership
•Outlook Contacts
•Create A New Contact
•Other Contact Fields of Interest
•Quickly Set Contact Object Using FullName
•Check If Worksheet Contact Exists Before Adding
•Iterate Through Contacts and Put Them In Excel Sheet!
•Fill Userform ListBox With Outlook Contacts
•Edit Contact Selection From Userform ListBox
•Send Email To Selected Userform ListBox Contact!
•Other Outlook Tricks
•Accessing Important Hidden Collections & Putting Into ComboBoxes
•Automatically Find Buried Folder Recursively – Custom Function