2025/01/15 update
Office Page Links
This TH20 task sends 2nd effort renewal-promotion via mail-merges to expires
Overview – the TH10 task is basically duplicated for TH20 – 2/8 – the membership.accbd file is used to run a query of expires which have an email address. Membership types print, pdf, and web are each selected within the query and each group of members are copied to Excel worksheets (print, pdf, and web). A mail-merge is run for each worksheet which sends each member a renewal notice.
⇓ 1. Start Task – Time-In, open files:
⇓ 2. Run/Complete Renewal-Promotion Effort:
⇓ 3. End Task – Time-Out, close files:
⇑ 1. Start Task – Time-in, open files:
open D:\fmaatc\0-mship\treasury.xlsx
> in name-hours > enter Date, Task = TH20, Time-In
⇑ 2. Run/Complete Renewal-Promotion Effort:
use D:\fmaatc\expires\mail-merge-inst.docx
⇑ 3. End Task – Time-Out, close files:
at treasury.xls
> in name-hours > enter Time-Out > save > close
☕ 🙂