Hi AngeC , once you have added the ABN to the card list display, right-click the list and choose Copy List to clipboard, then open Excel and paste the copied values. The ABN will be included.
Hi AngeC , the customer card export file is usually one row per customer. Maybe the advice was to delete columns you do not need (in Excel). The exported data can be easily copied to Excel then filtered etc as usual. Will this suit your requirements?
Thanks for the advice, I dont think it will work. The form I need I can see it on my command centre card list by adding in the customization . Unfortunately when I go to print/ export to excel it does not contain the ABN I require.
I then tried to buid it in the card list detail which didnot work either, unfortunetly it has 1 customer per page and doesnot export to excel. The customer name and the identifier on one row, and than on another row the ABN. With 2600 cutomers to filter through it makes it ineffectual. I really appreciate the time you took to respond, a heartfelt thankyou.
Hi AngeC , once you have added the ABN to the card list display, right-click the list and choose Copy List to clipboard, then open Excel and paste the copied values. The ABN will be included.
Thank you Mike_James you are a genius. Thankyou so much, you are wonderful. Merry Christmas
