Public
Receives email newsletters and stores them in SQLite
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.

📬 Newsletter Archive

Receives email newsletters and stores them in a SQLite database.

How it works

  1. receive.ts — An email handler. Forward your newsletters to the val's email address and each message is stored in SQLite (sender, subject, plain text, HTML, and timestamp).
  2. view.ts — An HTTP endpoint that lets you browse the archive in your browser.

Email address

Send newsletters to:

fgeierst-9b1cea667dc711f1b8261607ee4eb77e@valtown.email

Viewer

Open the archive viewer in your browser to see all stored newsletters.

Database schema

ColumnTypeDescription
idINTEGERAuto-increment primary key
from_addrTEXTSender email
to_addrTEXTRecipient(s)
subjectTEXTEmail subject
textTEXTPlain text body
htmlTEXTHTML body
received_atTEXTUTC timestamp

Tips

  • Forward newsletters to the val's email address to start archiving.
  • Use your email client's auto-forward rules to archive automatically.
  • The viewer shows up to 200 most recent newsletters.