Today we are going to learn about how to extract datatables /tables from outlook mail saved in your local machine (.msg file)
Prerequisite : Microsoft Office, Outlook should be installed on the system.
We are going achieve this using Vbscript.
But Before preceding with development lets learn What is an MSG file?
An MSG file is an email message, contact, appointment, or task created or saved within Microsoft Outlook. It may contain one or more email fields, which includes the date, sender, recipient, subject, and message body, or contact information, appointment details, and one or more task descriptions. MSG files are also compatible with other programs that use Microsoft’s Messaging Applications Programming Interface (MAPI).
What is VBScript?
Now that we are familiar with the technologies we are going to work on, Lets kick off with the development.
Don’t worry we are not going to go deep inside the vbscript.
So here is our input, it has a table with 4 columns and 2 rows.
Save it in the local folder.
Next drag Invoke VbScript activity and pass the path of vbscript code written by me.
Next Pass two arguments MSGFlePath,OutPutExcelPath
MSGFlePath - Path of the Msg file saved in local.
OutPutExcelPath - Path and file name of output excel.
This is will retrieve us the output as shown in screenshot.