Command for complete address book of ledgers
For Tally.ERP 9 Release 4.8 onwards
Copy the lines given below and paste it in the calculator pane of Tally.ERP 9, then press enter. You will see the report on screen. You can also export the report in Excel format.
SELECT $NAME, $_ADDRESS1+' '+$_ADDRESS2+' '+$_ADDRESS3+' '+$_ADDRESS4+'
'+$_ADDRESS5, $LedgerContact, $LedgerPhone, $LedgerMobile, $EMail FROM LEDGER