MYOB Training: Exporting MYOB Data for an Excel Mail Merge

We recently created 9 new training videos for our online MYOB training course and one of them demonstrated how to export and import data from an MYOB training company datafile. Exporting and importing is used to extract transaction and sales information and also customer or supplier card files from MYOB to use with Microsoft Excel in performing mail merges.

We have included the simple accounts list that we use in our online MYOB bank reconciliation course as a file you can download and open up in Notepad or Microsoft Excel. The image above shows what the file looks like when opened up in Notepad. It’s called a TAB-DELIMITED text file and this example includes a header record that gives you the name of each field (column)

ACCOUNTS

If you want to learn more about TEXT format (including CSV – comma separated values) files and how to manipulate this type of data using Microsoft Excel, take a look at our Microsoft Excel course 307 (visit this link and scroll down until you see the course contents of course 307: http://ezylearnonline.com.au/courses/microsoft-excel/excel-course-outline-2/).

If you need training on Microsoft Excel and data storage types you’ll be thrilled to hear that this course is one of 9 courses that are all included for one low price and LIFETIME student membership at the EzyLearn online Microsoft Excel course. Click here to enrol.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Should you learn MYOB, Xero or QuickBooks First?

We receive lots of bookkeeping course enquiries from students who are changing careers and want…

17 hours ago

What’s happening PEPPOL?

Am I speaking gibberish or just crazy? No, I'm speaking the language of eInvoicing! PEPPOL…

2 weeks ago

Xero Training Course Workbooks from under $35

If your finances are under pressure and you need to learn Xero then our current…

3 weeks ago

Do you want to earn an obscene amount of money?

Someone made contact with me recently and told me about an opportunity where "I could…

4 weeks ago

I’ve been away for 5 days and everything is out of date

There are times when I wish we all had the choice to only upgrade our…

1 month ago

Don’t give up

I was speaking with an intelligent lady in her early 50's and she was telling…

1 month ago