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 LabelsAt present, acquiring timely and readily accessible accurate information is a challenging task. To streamline and expedite this process, we have implemented a system aimed at enhancing overall efficiency. Our approach involves utilizing MSQuery to retrieve data from Synergetic, which is then conveniently formatted in Microsoft Excel for usability. Subsequently, we leverage the mail merging function in Microsoft Word to effectively structure and print labels containing the correct information.
We have created a guide below that includes how to:
Use MSQuery’s
How to Update the Query’s
How to Begin, edit and complete a Mail merge in Microsoft word.
How to access MS Query’s
The IT department has made developed a bunch series of MS query’s for Admin use and they are located queries specifically designed for administrative purposes, which are stored within the Synergetic Network Share Drive (If . In the event that you do not have access to this please tell your IT Administrator)drive, kindly contact your IT Administrator for assistance. For your convenience, we have provided below a set of screenshots illustrating the step-by-step process for accessing these queries, in case you encounter any difficulties or need a quick refresher in the future. Below are some screenshots helping show how to navigate to them if ever forgotten.
How to update MS Query’s
BEFORE USING ANY QUERY PLEASE FOLLOW THESE STEPS AS THE DATA MAY NEED AN UPDATE BEFORE EACH USE.
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
For your convivence IT have also made a bunch set of mail merges for each set of data but if you find that they . If these mail merges are not formatted correctly this process will help you create we have established a process for creating customized mail merges. By following this procedure, you will be able to generate a new mail merge that aligns with the administrative needs.
1. Create a new blank word document.
...