2025/01/06 update
Office Page Links
This TJ65 task creates/sends emails which announces pkagaaers have been mailed via USPS
This task is done after the Double A’er has been mailed via USPS. Emails are sent to Tprint members announcing that pkagaaer is mailed and webaaer/pdfaaer are available.
⇓ 1. Start – Time-In; Open files:
⇓ 2. Update Excel email address sheet:
⇓ 3. Run Mail-Merge:
⇓ 4. Stop – Time-Out, Close files:
⇑ 1. Start – Time-In; Open files:
open treasury.xlsx > in name-hours > enter Date > Task = TJ65, enter Time-In
open membership.accdb > open Report window
open D:\fmaatc\publish-Tprint\Tprint-members.xlsx
> add worksheet for current year for aaer being published
⇑ 2. Update Excel current year worksheet:
at Report window > set parameter Expire-Year: to the aaer being published
> double click “With Email Query” button (left side of Report window)
> copy query
> at Tprint-members.xlsx > in current year worksheet
> past query
⇑ 3. Run Mail-Merge:
at D:\fmaatc\publish-Tprint
> open m-mrg-tprint.docx > use instructions to run mail-merge
⇑ 4. Stop – Time-Out, Close files:
at treasury.xlsx > in name-hours > enter Time-Out > save > close
> close other files as needed
☕ 🙂