Google Docs™ relief for letters, slips and sensitive drafts

A calm guide to Google Docs™ for letters, slips and sensitive drafts

Documents are where an office speaks to the outside world: the permission slip, the welcome letter, the policy memo, the meeting minutes. Most document stress comes from two situations. Either the same letter has to be produced many times with different names, or a draft escapes before it is ready and someone treats it as final. This guide covers both, along with the handful of features that solve most everyday document problems.

The idea behind a merge letter

When thirty families need the same letter, the slow way is to type it once, then copy it and change the name, the date and the phone number thirty times. It takes an afternoon, and somewhere around letter nineteen a name gets left unchanged.

The faster way separates the two things that are really going on. There is a letter, which is identical for everyone, and there is a list, which holds what differs. In the letter, each place where something changes becomes a labeled blank such as {{Student_Name}}. In the list, each blank has a column with the same name. A merge simply walks down the list and fills the blanks, producing one finished letter per row.

The lab above lets you try this with a four-row practice roster. Notice what happens when a blank is matched to the wrong column: the preview shows a phone number where the date should be, and you can see the mistake before anything is printed. That preview step is the whole secret of a reliable merge.

Setting up your list so a merge works first time

• One row per letter. If a family has two children on the trip, decide whether they receive one letter or two, and arrange the rows to match.
• Clear headings in row one. Short names without punctuation are easiest to match: Student_Name, Trip_Date, Emergency_Phone.
• No blank rows in the middle. Many merge tools stop at the first empty row.
• Consistent dates and numbers. Type dates the way you want them to appear in the letter, because the merge copies exactly what it finds.
• Tidy the names first. Extra spaces and odd capitals in the list become extra spaces and odd capitals in every letter. The Sheets relief lab shows how to clean a whole column in one step.

Why drafts need a visible stamp

A shared document looks exactly as official on its first day as on its last. A budget proposal that is half finished, a staffing plan that has not been approved, a letter that still contains a placeholder — once forwarded or printed, each of these can be mistaken for the real thing. A large diagonal word across the page, such as DRAFT or CONFIDENTIAL, removes the doubt. Nobody pins a page marked “DRAFT — DO NOT DISTRIBUTE” to the staff-room noticeboard.

Docs includes a watermark option under the Insert menu, where you can type the word and choose how faint it should be. It applies to the whole document. Remember to remove it when the document is final, and consider naming the file to match, for example “Field Trip Letter — FINAL”. Use the toggle in the lab above to see how clearly a stamped page reads compared with a plain one.

Version history is your safety net

Every change in a Google Doc is saved automatically, together with who made it and when. Under File, then Version history, you can step back through earlier states of the document and restore any of them. This means a document can never be truly ruined by an edit, a bad paste or an accidental deletion. Before a big change, give the current version a name such as “Approved by principal” so it is easy to find later.

Share with the right amount of access

When you share a document, you choose one of three roles for each person. A Viewer can read. A Commenter can read and leave notes in the margin. An Editor can change the text. The most common sharing mistake is giving everyone Editor access out of habit. For a document that needs feedback rather than rewriting, choose Commenter. Suggestions then appear as proposals you can accept or reject, and the original wording is never lost.

Be equally careful with the general access setting. “Anyone with the link” means exactly that: anyone who is forwarded the link, on purpose or by accident, can open the document without signing in. For anything that names a student, a patient, a client or a member of staff, choose Restricted and add people by name.

Formatting that stays put

Documents drift out of shape when text is pasted in from emails and web pages, bringing its own fonts and spacing along. Paste without formatting, using Ctrl+Shift+V, and the new text takes on the style of the paragraph it lands in. For headings, use the built-in Heading 1 and Heading 2 styles rather than making text bold and large by hand. Styled headings can be changed all at once, produce an automatic outline in the left margin, and are read correctly by screen readers — an accessibility requirement for documents a public school publishes.

Approvals and acknowledgments

Many office documents need a decision: a budget request needs a yes, a policy needs to be read and acknowledged, a field-trip plan needs a signature from the principal. The usual approach is an email chain, which works until someone replies to the wrong version. A cleaner habit is to keep the document in one place, share it with the approver as a Commenter, and ask for a single comment that says “Approved” with their name. The comment is dated automatically and stays with the document. When approvals are frequent or pass through several people in order, a routing add-on keeps track of whose turn it is.

A short checklist before any letter goes home

1. Preview at least three merged letters, including the first and last rows of the list.
2. Search the document for the characters {{ to be sure no blank was left unfilled.
3. Remove any DRAFT watermark and rename the file as final.
4. Check the general access setting before sharing a link.
5. Print one copy and read it on paper. Mistakes are easier to see there.

Common questions