1 / 15

Mail Merge Instructions

Mail Merge Instructions. Efficiency with Monthly Contact (MC) Note: Sent out 76 emails in 1.5 hour time period. Received 38 MC return emails back within the same time period. The emails are still coming in! Email 20 days out (Even if a MC is not due)

regis
Download Presentation

Mail Merge Instructions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mail MergeInstructions

  2. Efficiency with Monthly Contact (MC) • Note: Sent out 76 emails in 1.5 hour time period. Received 38 MC return emails back within the same time period. The emails are still coming in! • Email 20 days out (Even if a MC is not due) • This ascertains that the parent has the base knowledge of their child’s current status in the class. • This opens up a two way communication with the parents. • Knowledge Base for parents • With the next phone contact with the parent – they are knowledgeable about their child’s grades – and the parents are able to ask appropriate and deeper questions Positives With This Process Mail Merge - 2012

  3. Step #1 Create An EXCEL Spreadsheet With The Information That You Desire In Your Letter. Mail Merge - 2012

  4. Step #2 Open Microsoft Word To A Blank Document Mail Merge - 2012

  5. Step #3 Click The Tab Named “Mailings” Mail Merge - 2012

  6. Step #4 Click “Start Mail Merge”And Then Choose Letter.. Mail Merge - 2012

  7. Step #5 Click “Select Recipients”(Choose USE EXISTING LIST – this will open up your documents. Choose the EXCEL spread sheet that you wish to use) Mail Merge - 2012

  8. Step #6 Type Your Letter(If you need to add information for a specific student, click “Insert Merge Field,’ and click on the specific information that you want to choose.) Mail Merge - 2012

  9. Step #7 Click “Preview Results”This is to ensure that the letters are correct Mail Merge - 2012

  10. You need to choose “Edit Individual Documents: This will produce all of your letters in one long document  Step #8 Click “Finish & Merge”This will give you three options Mail Merge - 2012

  11. I have found that if you email it to their personal email vs. emailing through VSA – you have a greater return rate. Step #8 Copy the Specific Letter, And Email It To The Parent Mail Merge - 2012

  12. Concerns Alternatives • EXCEL does not like to show percentages. • In the form letter there is a 0.% • This way, the correct percent will be documented • You are able to add a column with the parent’s email address….. • Then you click “Send email Messages” instead of “Edit Individual Documents.” (This is a bit more time consuming) Mail Merge - 2012

  13. SUMMARY :NINE EASY STEPS TO A MAIL MERGE Mail Merge - 2012

  14. SUMMARY :NINE EASY STEPS TO A MAIL MERGE Mail Merge - 2012

  15. SUMMARY :NINE EASY STEPS TO A MAIL MERGE Mail Merge - 2012

More Related