2025/01/06 update
Office Page Links
This TJ60 task creates/sends emails which announces webaaer and pdfaaer are available and provides renewal information
This task is done after d.fmaatc.org is installed as the new fmaatc.org release. Emails are sent to Tpdf and Tweb members announcing that webaaer and pdfaaer are available. The emails are also renewal notices for members expiring for the current year. There are four different emails. Each are produced via a mail-merge. Instruction documents are at D:\fmaatc\publish-Tweb-Tpdf:
- m-mrg-tpdf-fut.docx
- m-mrg-tpdf-ren.docx
- m-mrg-tweb-fut.docx
- m-mrg-tweb-ren.docx
⇓ 1. Start – Time-In; Open files:
⇓ 2. Update Excel email address sheets:
⇓ 3. Run Mail-Merges:
⇓ 4. End Task – Time-Out, close files:
⇑ 1. Start – Time-In; Open files:
open treasury.xlsx > in name-hours > enter Date > Task = TJ60, enter Time-In
open membership.accdb > open Report window
open D:\fmaatc\publish-Tweb-Tpdf\Tweb-Tpdf-Eaddresses.xlsx
⇑ 2. Update Excel email address sheets:
Four queries are run via the Report window:
- Renewal – Email web (uses current fiscal year as Expire-Year parameter)
- Renewal – Email pdf (uses current fiscal year as Expire-Year parameter)
- Futures – Email web (uses current fiscal year +1 as Expire-Year parameter)
- Futures – Email pdf (uses current fiscal year +1 as Expire-Year parameter)
Each query is run/copied/pasted at D:\fmaatc\publish-Tweb-Tpdf
> into Tweb-Tpdf-Eaddresses.xlsx worksheet
> pdfFut, pdfRen, webFut, or webRen
> save file
⇑ 3. Run Mail-Merges:
at D:\fmaatc\publish-Tweb-Tpdf
> use each m-mrg-…docx instructions to run a mail-merge
⇑ 4. Stop – Time-Out, close files:
at treasury.xlsx > in name-hours > enter Time-Out > save > close
> close other files as needed
☕ 🙂