Hurley
2 years agoContributing User
Export client details
I want to export all my client contract details in excel, names, numbers, addresses etc. I cant find a way of doing this, any solution?
Hi Hurley
Thank you for your post.
The Export options for MYOB Business don't have Contacts as an available feature. What I can suggest as a workaround is to get a Contacts report. To do this, kindly go to Reporting >> Reports >> Search for Contacts (Which is also under the Business tab). You can then click on Export and choose Excel.
This report should show you the Name, Phone, Email address, and other columns that you can select by clicking Customise. You can also click on Contacts to choose contacts that will show on the report or to untick Show inactive.
Let me know how it goes.
Please feel free to post again. I'm happy to assist further.
If my response has answered your enquiry please click "Accept as Solution" to assist other users in finding this information.
The list of exports columns does not contain firstname and surnames of individuals. Neither does it contain the type company or individual. Also it contains a column saluatation but the input screen does not have saluatation.
Hi Sasitharan,
Thank you so much for your post and my apologies for the late response. The Contact list report is the best option, but it doesn't support adding extra columns or exporting to Excel (only as a PDF). However, you can get a contact list as a PDF and then convert it to Excel. To access this list, go to Reports > All reports > Contacts (under Business reports). This report will include Card Name, Phone Number, and Email address.
Feel free to post again, we're happy to help!
Regards,
Earl
Hello Earl,
The contact report has an option to customise wherein you can add additional columns and export to Excel.
My question is that the extra columns does not contain
1. Designation
2. First Name
3. Surname or Familiy Name
The second question is one of the additional columns is 'Saluataion' but there is no prvision for it in the input screen.
Regards
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.