Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

I draft letters that have the same basic language but with a few variations for

ID: 657257 • Letter: I

Question

I draft letters that have the same basic language but with a few variations for 50+ people (e.g. name; bill amount etc). I edit these manually and feel that there must be an easier/more automated way to do this. I was wondering if someone could tell me a smarter way to get this done. Is there a way I can make the basic letter; leave fill-in-the-blanks; and have an excel file or something that will auto-fill the blanks w/ a column of info; and finally save the letters separately whether via Word/Adobe or any other solution?(I've got both on Mac and Windows machines but am open to other solutions). Thank you for your help!

Explanation / Answer

If you have MS-Office or LibreOffice you need to look at the help files for "Mail Merge" - there are lots of other ways to do this sort of task depending on the complexity of what you are doing.