Set a breakpoint in the custom function source code.

In VS Code, open your source code script file ( functions.js or functions.ts).

A new Excel workbook will open with your add-in already sideloaded and ready to use.

Select F5 (or select Run -> Start Debugging from the menu) to begin debugging.

From the Run drop-down menu, choose Excel Desktop (Custom Functions).

Choose View > Run or enter Ctrl+Shift+D to switch to debug view.

Choose Terminal > Run Task and type or select Dev Server.

This will monitor and rebuild for any file changes.

Choose Terminal > Run Task and type or select Watch.

Open your custom functions root project folder in VS Code.

GLOBAL.Desktop debugging for the Mac is not available but can be achieved using the browser tools and command line to debug Excel on the web).

Give the path of your created new Microsoft Excel file.

In desktop debugger mode we can read the content of outlook email body with this statement “ctx.log(“Email Body: ” + (0)) ”.

Here the email is getting filtered by subject name as “Email Body into Excel through SAP Intelligent RPA”. Now we can edit the code as per our requirement.

Once we click on build the below code will be generated.

Click on save button and build to generate the code. Right click on Global from work flow perspective and create a new work flow and give the name for work flow and click on save.įrom Activities we can drag and drop custom activity and rename it to “email body into excel” or whatever you want.

Select outlook and excel integration checkbox and click on save button.

Right click on script perspective and click on Include library script to select outlook and excel integration.

Select outlook and excel integration from library:

Give the project name, title, client name and comments are optional and click on save.ģ.

Open the desktop studio > Click on File and click on new project.

Finally, click on Bot to read and save outlook email body content into MS Excel.Ĭreate a new Microsoft Excel file to save the outlook email body content into it.Ģ.

Drag and drop, save and build to generate the code.

Select outlook and excel integration from library.Create a new project in desktop studio.Steps to Write & Save Outlook Email Body into Microsoft Excel:

Please note that in this scenario the email is filtered by subject name. Coming to this blog post we will see below how to write outlook email body into Microsoft Excel and save the file. Almost all private and government sectors use Microsoft Excel and It plays very important role to perform multiple activities on a daily basis. Microsoft Excel is most popular spreadsheet.

Ms excel debug mode