2025/01/02 update
Office Page Links
This TH35 task sends 4th effort, renewal-promotion letters to expires
Overview – This is the 4th renewal effort. The membership.accbd file is used to create a report of expired print type members. 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 treasury.xls
> name-hours worksheet; enter Date, Task = TH35, Time-In
Open D:\fmaatc\expires\TH-expire-letters
> delete prior year’s files
Open 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 (rptExpsLtrsTprint) 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-print 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 – rptExpsLtrsTprint-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+):
Go to Thunderbird @ FMAATC… > Inbox > TH-expire > TH35-Fedex-Office
> select “TH35 Print-Renewal Letters” from the prior year
> click Reply to icon > select and copy prior year’s text
> paste text at top of email
> delete old prior year’s text at bottom
> edit Subject by deleting “Re: ” (this leaves the subject as “TH35 Print…..”)
> take a snapshot of the file to be attached and replace last year’s snapshot
> attach the .pdf file – drag and drop works good to accomplish this
> verify “Copy message to:” field is “TH35-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
> open pdf file and send to the LAN printer
⇑ 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 files:
At treasury.xlsx
> name-hours worksheet, enter Time-Out > save > close
> close other window as needed
☕ 🙂