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 LabelsMS Query’s and Microsoft Word Mail Merging is a new process we are beginning to use at Calderwood this guide will help you at Admin understand how to use them for Labelling purposes. This guide includes how to access the Query’s, how to update the Query’s to newest data from synergetic, and how to Begin, edit and complete a Mail merge in Microsoft word.
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 update MS Query’s
As synergetic is ever changing with new students, old students new contacts and so on, before beginning a mail merge it is recommended that you update the existing Microsoft Query. Make sure synergetic is open prior to opening the spreadsheet and than click the refresh all button under the data tab. (follow the screen shot for help) After this is complete please save the spreadsheet so a newer version of the data is readily available.
...
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.
...