2025/01/15 update
Office Page Links
This TH22 task Sends renewal-promotion letters to expires without email
Overview – The membership.accbd file is used to create a report of expired print type members without an email. The report is saved as a PDF file, printed, and pages are folded/inserted/stamped/mailed.
⇓ 1. Start Task – Time-In, open files:
⇓ 2. Create Report – type print:
⇓ 3. Print Expire-Letters (via FedEx if 20+):
⇓ 4. Print Expire-Letters (Local if 19 or less):
⇓ 5. Mailing Letter Shop Work:
⇓ 6. End Task- Time-Out, close files:
⇑ 1. Start Task – Time-in, open files:
open D:\fmaatc\0-mship\treasury.xls
> in name-hours; enter Date, Task = TH22, Time-In
open D:\fmaatc\expires\TH-expire-letters
> delete prior year’s files
open D:\fmaatc\0-mship\membership.aacdb
> click Report in Switchboard window (Report window opens)
> enter Expire-Year parameter as fiscal-year minus 1 (example: for fiscal 2018 use 2017 as the parameter)
open report (rptExpsLtrsNEmail) in design view
> replace the two-year renewal years to be current (example – 2025—2026)
> save
⇑ 2. Create Report – type print:
double click Exps-Ltrs-NEmail button > print preview opens
> use page bar to note the total count
> click PDF….. on tool ribbon > Publish as PDF….. window opens
> add page count to file name (example – rptExpsLtrsNEmail-30)
> navigate to D:\fmaatc\expires\TH-expire-letters
> click Publish > Export – PDF opens > Close
> close Print Preview.
> if the total page count is greater than 20, continue with Step 3
> if the total page count is 20 or less, go-to Step 4
⇑ 3. Print Expire-Letters (via FedEx if 20+):
at Thunderbird > FMAATC… > Inbox > TH-expire > TH22-Fedex-Office
> select TH22-text > copy message body
> click Write > paste text into message body
> from body > ctrl+x the email address > past into the To: field
> from body > ctrl+x the subject > past into the Subject: field
> edit the total number of pages
> attach D:\fmaatc\expires\TH-expire-letters rptExpsLtrsNEmail.pdf file
…drag and drop works good to accomplish this
> verify “Copy message to:” field is “TH22-Fedex-Office on fmaatc.org@gamil.com”
> send the message – wait for “Sending Message” window to complete
> FedEx should send an email at their completion (might have to call them)
> pickup from FedEx Office at 2616 Baseline Rd.; Boulder, CO 89305; 303-494-2622
⇑ 4. Print Expire-Letters (Local if 19 or less):
Open D:\fmaatc\expires\TH-expire-letters rptExpsLtrsNEmail.pdf file
> print
⇑ 5. Mailing Letter Shop Work:
Printed pages need to be folded for 3-7/8″ x 8-7/8″ windowed envelopes, inserted, sealed, stamped and mailed
⇑ 6. End Task- Time-Out, close file:
at treasury.xlsx
> in name-hours, enter Time-Out > save > close
☕ 🙂