Forum Discussion
Hello Tracey,
Thank you but the Card List (Detail) report that you recommended prints one page per customer. I ended up with a 400 page report. All I want is a spreadsheet with one customer per line (as per the Summary report) but with the option to choose different fields to display as columns. Cheers, Ian
Hi Ian-Belgamba
You can customise that report by clicking on Insert/Modify>>Show Hide.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
- Ian-Belgamba3 years agoExperienced Cover User
Thanks Tracey, I am aware of how to insert/modify and select from available columns, but the problem is still that this option only applies to the Card List [Detail] report which prints one customer per page. I want a tabular format as per the Card List [Summary] report but this does not give those options that you described. I want a customer list report on a few pages which I can put into Excel and copy their email addresses. I dont want a 400 page report. Cheers, Ian
- PaulBihet3 years agoUltimate Partner
Hi Ian
I would suggest you try using the Import and Export assistant (Located under the "File" menu
1. Select Export Data
2. Select Cards and Customer Cards
3. Select Tabs or Commas doesn't matter
4. Select field from left Column Click Add button to transfer to fields to export (Scroll down to find Co./Last Name
5. Select Export
6. This will create a text file which can be opened in Excel
- LRBooks613 years agoUltimate Cover User
Hi
you should be able to export the created report to excel from the report in MYOB
there is a drop down list on the top left hand side you can export and email etc
select export and then excel
this will produce the report as an excel report
hope that helpsLisa