In very short if you want to set up the report in ER you would have to do the following steps. On phone so no screenshot or so.
1. Create a model (go to er configurations and create a root).
In the model start with a root node, add a record list node and under the record list node add the needed fields in the Excel sheet. Keep in mind the correct formatting and stick to the formatting on the data entity. Click complete on the model status.
2. Create a data model mapping ( not sure if you can create a separate model mapping in 7.3 otherwise create it under the model by clicking map model). Click mapping to model (to destination is for imports).
In the model mapping add the data source table records and in the drop-down select your data entity (view or table selection is possible as well). Click ask for query if you want to filter the output, leave it blank if you want to export the entire table. Set status to complete.
After this map the table name to the record list and then map each required table field to the model by clicking bind.
3. Create format (leave file format blank. This is used for imports).
Format for export will be Excel. Electronic Reporting on Excel works with name manager in Excel. Easiest is to create a table.
Alternatively you can Create headers on row 1. Select your entire table row on row 2 (range is equal to your table range) and me it export range or something like that. After this give each cell in row 2 a name equal to it's header.
After this go to your format and click import from Excel and disable create sheet and format value is not needed, this is for imports. You should now have your format created like your named ranges. After this map your model to the format values. Click complete on the status.
4. Create a destination for your format.
Go to electronic reporting Destination and configure a new one and select your Excel format. Select the format component and go to settings. Configure email and click save.
5. Go back to your format and select run
Configure batch job for running and output should be selected like your destination.
This might be overwhelming but these are the high level steps required to configure this via electronic reporting.
Hope this helps
Best regards
Ties