The pattern library shows what text looks like in each of the general styles
The style sheet is posted here
In addition to preparing the newsletter for publication, here’s how to get the addreses in the right places
- Download all levels of members from the website
- Sort by membership (printed and electronic)
- Copy each class to its on page for manipulation. Do not delete the main page in case you have questions.
To prepare for printed mailing
- Delete columns A-G, N-U, W-Y (confirm contents of Z- admin) AA-AC, AE-AL
leaving Address1 and 2, city, state,zip, country, expires, admin and display name- The printer uses the expires date as part of the first line on the labels
- Remove Kim and Jason Coleman
- Make sure YOU are on the list to get the printed version. Looking thru old issues in print is easier than searching thru the pdfs
- Replace Never with AutoRenew
- Prefix expiration date with exp.
- Sort by zip to confirm all addresses use +4 version
https://tools.usps.com/zip-code-lookup.htm?byaddress# - Make appropriate corrections in the online membership list
- Save the page as csv and send to printer with the press version of the RootesReview
- Generally include in the cover note: Total number of names, mention any that need to be hand addressed (to UK), +10 extra copies to membership chair
For electronic
- Replace Never with a far future date. I have been using 1/1/2050
- Delete colums A-E, F-U, W-Y (confirm contents of Z-admin), AA, AB, AE-AM
- From time to time import the first first names of member and joint member for import into Mailchimp
- From time to time write to people who have unsubscribed and remind them about the electronic version of the newsletter.
- They must go to https://www.teae.org/resubscribe-to-emails/ to signup again. You can not directly add them to the list
- Save the file as .csv for import into mailchimp
- Wnen you import names, add a new tag so you know who should be getting THIS electronc version
- Generally I copy the last campaign and adjust dates, titles etc before sending.
- Please note: Our account only allows for 500 names for free. We could carry only the electronic people but I am loathe to do that.
- Be sure you have uploaded the electronic version to the website.