Use a Correspondence Record Sheet Template to record each inquiry’s date, contact, purpose, response, owner, and next follow-up in one reusable layout. You should be able to open any entry and see what you requested, what came back, and what you need to do next.
Your correspondence record sheet works best when you keep the core fields consistent and add specialized details only where you need them. Whether you contact an archive, answer a customer, or speak with a parent, give each correspondence record a clear reference and enough context to resume the conversation.
Which Format Should You Choose: Word, Excel, or PDF?
Choose Excel for an active correspondence log that you need to sort by follow-up date; choose Word for flexible written entries and PDF for a consistent printed layout.
Use the same core fields in each format so you can change your workflow without redesigning your records.
| Your requirement | Word | Excel | |
|---|---|---|---|
| Edit the sheet’s layout | Flexible tables | Adjustable columns | Requires editing tools |
| Write detailed notes | Expanding text | Wrapped cells | Available field space |
| Sort pending entries | Basic table sorting | Sort and filter | Manual review |
| Complete by hand | Print a blank copy | Set a print area | Print a fixed layout |
| Enter information digitally | Editable document | Editable workbook | Fillable fields if provided |
For a communication log template you update frequently, freeze your spreadsheet’s header row and use consistent status choices. Check your print preview before distributing a paper copy, especially when your notes columns are wide.
If you use the Williams College PDF, you have a checkbox for continuation on the reverse side. When you continue an entry, repeat its reference on the additional page so you can reconnect loose sheets.
What Fields Should Your Sheet Include?
Include enough fields to identify the exchange, retrieve the original message, and assign the next action.
Copy this blank layout into your document, or use its labels as spreadsheet column headings:
- Entry ID: ________
- Date sent or received: ________
- Direction and channel: ________
- Contact name and organization: ________
- Contact information: Email ________; phone number ________; mailing address ________
- Subject or purpose: ________
- Request or message summary: ________
- Original correspondence location: ________
- Owner: ________
- Status: ________
- Response date and summary: ________
- Next action: ________
- Follow-up date: ________
- Results and closure date: ________
Complete only the contact details relevant to your exchange. For an email inquiry, you might need an email address and organization; for a mailed request, include the full mailing address.
Keep your response separate from your results. In the response field, record what your contact said or supplied. In the results field, record whether that resolved your request and what remains outstanding.
Use an exact file name, folder reference, or message identifier for the original correspondence location. A note such as “saved in email” gives you too little help when you return to the entry later.
How to Complete an Entry and Track the Response
Create your entry when you send or receive the initial message, then update it as the exchange progresses.
- Record the request. Give your communication log entry a unique ID and summarize the specific question.
- Assign responsibility. Name the person who will check for a response, even when you handle the inquiry yourself.
- Set the next review date. Use any promised reply date to plan your follow-up. Otherwise, choose a reasonable review date for that contact.
- Record the reply. Add its date and save the original message or attachment under the same reference.
- Resolve or continue. Close your entry when you have recorded the outcome, or assign another action and date.
Use this fictional communication log example as a model:
Entry ID: GEN-MORRIS-A
Date and channel: November 2, 2026; outgoing email
Contact: County archive reference desk
Purpose: Request an index search for a Morris family probate file
Owner: You
Initial status: Awaiting response
Follow-up date: November 9, 2026
Response: November 6, 2026; archive supplied a file reference and explained the copy-request process
Next action: Submit a separate copy request linked to this entry
Outcome: Index inquiry resolved; copy request remains open under a linked entry
Closure date: November 6, 2026
Keep your initial request visible as you add updates. If a reply answers only part of your question, record the unresolved point explicitly.
Adapt the Sheet for Genealogy, Business, or School
Keep your core layout and add only the fields your setting requires.
- For genealogy research: Add the surname, ancestor’s identifying details, repository, record citation, charge, and refund. Keep a citation for material received separate from the location of your correspondence. Record a charge when assessed and a refund when received; leave pending amounts clearly marked.
- For business administration: Add the customer or vendor reference, department, project code, and priority. For project management, connect your correspondence record to the relevant task or document reference. Use the owner field to make handoffs explicit.
- For school communication: Add the student identifier, parent or guardian relationship, and agreed action. Keep your parent communication log factual: record the concern discussed, the response, and the arrangement for checking progress. Follow your school’s rules for access and storage.
When you maintain a contact log separately, use a shared contact reference to connect it to your correspondence entries. Update an address or phone number in your contact directory, while preserving the details needed to interpret earlier exchanges.
Avoid adding every optional field to your daily sheet. If you rarely record charges, keep that field in your genealogy version and preserve more space for notes elsewhere.
Keep Every Inquiry Linked to Its Next Step
Keep your correspondence log current by giving every open inquiry an owner and a dated follow-up action.
Choose a regular review time and check entries with approaching or overdue dates. After each reply, update the response, identify any remaining work, and record the results when you close the inquiry.
Start with the blank layout, retain the fields you use, and keep the original messages under matching references. Before closing an entry, confirm that you have saved the reply and recorded the outcome.
Frequently Asked Questions
Should you use one row per message or one row per inquiry?
Use one row per inquiry when your exchanges are short and easy to summarize. For a longer thread, give each message its own entry and connect those entries with a shared inquiry reference.
What should you record when you receive no response?
Record “No response as of” with the date you checked, then enter your next follow-up action. If you decide to stop pursuing the inquiry, record that decision and your reason in the results field.
How long should you keep a correspondence record sheet?
Keep your correspondence record sheet for the period required by your organization’s retention policy or applicable obligations. For personal genealogy research, retain the correspondence alongside the research files it helps explain.
Should you copy the entire response into your sheet?
Summarize the response and record where you saved the complete message. Include exact wording when you need to preserve a commitment or an important qualification, and clearly identify it as a quotation.