MS 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 At 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.
...