Hi miss, if the exam question just says 'create the datafile from the information given', does it have to be a database file created through the mail merge in word? or can you do it externally on an excel file and use it?
Hi Ray. While a data source can be done in Excel it will not be able to be merged with your Word document and as such should not be used. The data source is only done through three means: 1. Create the table (in MS Word) just as I have shown you and then link it to the letter. 2. Create the table in MS Access and then link it to the letter. 3. Select Create New List ( this also links to Database) and will be used to do the merge. Google Sheets will be the other software that is accepted to do the merge (as in my Autocrat video) but that will not be used for the exam seeing that you will be going in face to face for the exam and will be using the computer at your school with Microsoft on it.