SWAG 1 Activity #6: Mailing List Maintenance

This activity makes use of a computer with an Excel spreadsheet that is provided. Note that the two columns that are to the right of the ZIP or postal code column are hidden. You may “unhide” these after the task has been completed to help identify the codes that the client is unable to correct.

Explain to the client, “We have discovered that 23 of the letters were sent to patrons using incorrect ZIP codes. We need to find out which patrons have incorrect ZIP codes and make the corrections on the computerized mailing list.”

Activity 6 Tasks
Task # Problem Task Resources
1 After the last mailing, several letters were returned with wrong ZIP codes. Which patrons have an incorrect ZIP code? Compare Mailing List with Master Database to identify incorrect ZIP codes. Form G, Form H
2 We need to correct the wrong ZIP code records on the Mailing List. Use the Master List to Correct the Mailing List on the computer. Mailing List on computer, H

Files:

  • Activity 6 Instructions (PDF)
  • Mailing List Printed (PDF)
  • Master DB Printed (PDF)
  • SWAG 1 Red Label Side 1 (PDF)
  • SWAG 1 Red Label Side 2 (PDF)
  • Activity 6 - Mailing List Errors (Excel)

Client orientation and instruction: 5–20 minutes

Typical activity duration: 60–120 minutes