...
Take a copy of last month’s report , AAIR-202106-JUNE.xlsx, for example to your C:\ drive
Rename it to AAIR-202107-JULY.xlsx (note, we’re always extracting data for the previous month just ended)
...
AND Y50.PARTY_ID = Y53.PARTY_ID
AND M01.AIRCRAFT_ID (+) = Y05.AIRCRAFT_ID
AND M01.YEAR_CALENDAR_NBR (+) = TO_NUMBER(TO_CHAR(SYSDATE,'YYYY')) - 1 ;
...
Step 4 –
Export the data to a text file. Import that text file to the new spreadsheet, save a copy to the archive (where you got the original xlsx) and email this month's report to Eric Lanthier
...