Straight table to excel with bookmarks

[Rfoot]

Hi,

I have created an automation that simply applys a bookmark, gets straight table data, adds to excel then sends email.

They all seem to be successful as each block has info im expecting.

EG:

but in the Excel sent to my inbox, it is empty except for the column headers.

Strangely I do the exact same method but with far less data the excel populates perfectly.

Is there something I should be aware of with larger datasets? But in fairness its only 400ish rows of data. Pretty standard report.

Regards,

Ryan

[Florentin74]

If you have a loop over recipients, remember to close the workbook session for each loop and remember to delete the excel table as well.  Use a variable to build the insert statement in and finally use the "Add rows to an excel worksheet table (Batch)" .