Some members request to receive newsletters and other communication via paper mail. However, some of these members have not provided this data via their web profiles; and so, the AHS relies on address data in a Google sheet managed by the newsletter editor.
All necessary address data should be available in our postgres database.
Things todo:
figure out which members (a) request paper mailings, and (b) do not have address data in postgres.
possibilities:
if the number of such members is small, then we can manually enter the data using the /admin view/
if the number of such members is medium/large, then we can write a script that automatically pulls the data from the Google sheet
Some members request to receive newsletters and other communication via paper mail. However, some of these members have not provided this data via their web profiles; and so, the AHS relies on address data in a Google sheet managed by the newsletter editor.
All necessary address data should be available in our postgres database.
Things todo: