I would like to create a tracking sheet for mail recieved

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to creat an electronic tracking sheet for mail receied on a
daily basis
 
Start a new workbook (in Excel). Name a sheet mail tracking. Name
some columns - Date received, Postmark Date, Recepient, Addressee,
Size, Weight, Content, Check Amount - whatever you want to track.

As you receive mail, fill in the corresponding columns with
appropriate data. Come up with a designation for missing information,
or items not applicable (check amount is not applicable when there's
no check).

Use a single row for each mail item.

If you want, insert a row at the beginning of your sheet, call it ID
or something. Use it to number mail items, so that you can look them
up later if needed.

Hope that helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top