2025/01/15 update
Office Page Links
This TH10 task sends 1st effort renewal-promotion via mail-merges to expires
Overview – January 1st – 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 = TH10, 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
☕ 🙂