This article is a 2 part article the 1st part explaining the process of how to access the pre created Microsoft Query’s that us at IT have created for you. If you require any more MSQuery’s please let us know what you need included in it and we can create another one.
The 2nd part of this article is to help step through how to mail merge the MSQuery information in Microsoft Word in order to create Labels.
How to access MS Query’s
IT has made a bunch of MS query’s for Admin use and they are located within the Synergetic Network Share Drive (If you do not have access to this please tell your IT Administrator). Below are some screenshots helping show how to navigate to them if ever forgotten.
How to Mail Merge in Word
IT have also made a bunch of mail merges for each set of data but if you find that they are not formatted correctly this process will help you create a new mail merge.
1. Create a new blank word document.
2. Navigate to the Step By Step Mail Merge Wizard: Mailings → Stat Mail Merge → Step By Step Wizard. Now we will show how to use the wizard
The Wizard is formatted on the right side of the screen, pull it out some more to make it more visible. The Bottom section of the Wizard is just for progressing the wizards pages. If you make a mistake or Forget to make a change in the Mail merge process the previous button will always take you back to the previous step. Now lets help you use the Mail Merge Wizard for Labels.
Wizard Page 1:
Select Label than select next page (Refer to screenshot for help)
Wizard Page 2:
Please select Use Current Document, Label Options > L7159. (Or other label type if using different Labels) Select Ok on the pop up tab than proceed to the next page (As shown in Photo)
Wizard Page 3:
Select Use an Existing List than Select a different list. Locate the Excel document you wish to use from the Synergetic Network Share Drive, For this Demonstration we will use the Stu Number & PC Spread Sheet. Select Open on the Pop up tab to use the selected document. After selecting a File to use 2 pop ups will show up press “OK” to both of them. Than Proceed to the next page. (all as seen in the photo below)
Wizard Page 4:
Please press more Items and in the pop up menu select all fields that are wanted to show on the label. In the example we have only selected 2 items for demonstration purposes.
Once all Items have been selected we encourage the user to edit the layout of their labels and preview them. This may require Trial and error as each students name is different length and may need to be tweaked please preview the labels once they are re formatted, if the formatting is wrong please go back to previous step to start changing again.
Only the first label in the top left needs to be edited in order to press update all labels to copy the fist labels formatting to all existing labels.
Each item will be placed in-between to arrow symbols (< and >) in order to edit the formatting of the labels please do not edit the symbols or anything between them. Feel free to add spaces or line breaks between Items.
All the above mentioned is displayed below in the 2 example screen shots.
Wizard Page 5:
Once formatting is correct and previewed. Please commence onto Page 6 of the Wizard.
Wizard Page 6:
Now that the mail merge is complete please close the wizard. Or continue editing individual Labels as shown in the wizard.
Saving the Document:
Please Save the Document in the same Synergetic Network Share Drive Folder as the rest of them (Microsoft Query Synergetic Reports Folder) and Label it the same as the spread sheet it used with a completed mail merge after and the label format used. (As shown in the screenshot below)
If at any point in this guide you get lost please reach out to IT at helpdesk@calderwood.nsw.edu.au or call our extension 717 and we will help resolve any issues.