is it possible to create a straight table using macro and automaticaly send mail by exporting the daily data?
Not sure about that, But the better approach would be to show and hide the Straight table using triggers/macro and then export the data using it.
Performance Point of view, Macros should be avoided.
The better Approach, Create a Table in the script with like required straight table dimensions & expressions and then export to Excel with small macro.
Retrieving data ...