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 We have created a guide below that includes how to:
...
BEFORE USING ANY QUERY PLEASE FOLLOW THESE STEPS AS THE DATA MAY NEED AN UPDATE BFORE 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.
...