What you'll learn:
- You will be able to fully automate Outlook tasks using excel vba and also will get the knowledge how we connect the external applications using excel vba.
- We are going to learn early and late binding methods which are going to be used in connecting other applications as well the same way.
- There are multiple real projects discussed in this series for you. Questions came from students are answered here. Certainly, will save your lot of time
- How to send Outlook Emails via VBA
- How to provide outlook subject lines , recipients through excel sheets to fully make users powerful
- How to create appointments and meeting calenders
- What are the outlook classes and why and where they are used. NameSpace class, Mailitem , folders classes etc
- Loop through emails inside outlook folders or user created folders and extract the information
- how to download attachments from emails by searching subject lines or date ranges.
- Move emails from one folder to another
- How to send emails at particular time and how to track if client has replied on same or not.
- How to send 100 emails to different senders with different subject lines and different recipients.
- How to reply with complaint numbers.
- Send specific range as a snapshot to Users - Mind blowing
- Split and export outlook messages on your system
- You will also learn the outlook VBA Topic in this session other than excel vba
- How to create hyperlinks and attach images via excel vba and customize them.
- How to send bold or italic formatted words in email body using ms word using excel VBA- Highly Advance
We are learning how to connect Outlook with Excel VBA.
Early binding approach and Late Binding Approaches. Advantage/Disadvantages
Sending auto emails, Customizing the email subject lines, body , signatures , to , cc, bcc ,attachments
Copying or moving folders in outlook
Copying or moving emails from one folder to another
How to extract the files from outlook emailsand save them on your machine.
How to work with default folders, own created folders/subfolders
How to use file dialogs in emails giving choice to select whichever folder user want to choose.
How to send data as a snapshot in outlook body
There are so many things - anything which you think is a part of outlook application and you would like to automate it - can be done.
Multiple projects for you coming from students directly
For eg. how to set up meeting calendars
How to reply to clients with some unique request number
How to extract the mobile number and other information from body of outlook and export it all in excel cells,
How to use hyperlinks
How to send emails and update their status as done in excel
How to handle email addresses, body content, subject lines for outlook using excel sheets.
How to send emails with snapshots
How to use html tags and provide content bolder and also choose images if you want to send in body of an email.
Many personal projects for your confidence and exposure for eg. how to send formatted email using ms word. How to bold texts and attach logos , any logo that you like to use.
Early binding and late binding - Advantages and Disadvantages of both approaches.
Learn outlook VBA as well . In section 2, You will see how to write same excel vba codes with little caution on outlook vba editor.
Your questions will be answered with in 48 hours. Always there to assist you.
