https://community.blueprism.com/t5/Product-Forum/Data-manipulation-with-Huge-volume-of-records-in-grid/m-p/46122#M2184 Use the OLEDB VBO to query the file without opening it in Excel. Mon, 05 Feb 2018 15:22:00 GMT John__Carter 2018-02-05T15:22:00Z https://community.blueprism.com/t5/Product-Forum/Data-manipulation-with-Huge-volume-of-records-in-grid/m-p/46121#M2183 I have a grid which will have around 50k - 1Lakh records. And I need to filter the record with status as failure and send those rows in a single email. Note: The grid is spying n windows mode. My Appraoch:   1) I tried capturing the table and read the values using "Read Table". But Blue Prism got hanged due to high volume of data. (Failed)                            2) Gave SHIFT + CTRL + END and copied values to clipboard and split using "Split By Line" under "String" VBO (Failed) Please help me in advising on what approach to follow to deal with Data manipulation with huge volume of records. Mon, 05 Feb 2018 14:08:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-manipulation-with-Huge-volume-of-records-in-grid/m-p/46121#M2183 Anonymous 2018-02-05T14:08:00Z https://community.blueprism.com/t5/Product-Forum/Data-manipulation-with-Huge-volume-of-records-in-grid/m-p/46122#M2184 Use the OLEDB VBO to query the file without opening it in Excel. Mon, 05 Feb 2018 15:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-manipulation-with-Huge-volume-of-records-in-grid/m-p/46122#M2184 John__Carter 2018-02-05T15:22:00Z