2025/01/02 update
Office Page Links
This TH40 task deletes member’s email address when it is undeliverable
⇓ 1. Start Task – Time-In, open files:
⇓ 2. Extract Failed Email Address:
⇓ 3. Update Membership Record:
⇓ 4. End Task – Time-Out, close files:
**** Expanded task steps follow ****
⇑ 1. Start Task – Time-In, open files:
Open D:\fmaatc\0-mship\open treasury.xlsx
> name-hours worksheet > enter Date, Task = TH40, Time-In
Open membership.accdb
> click Update button in Switchboard window (the Update window opens)
⇑ 2. Extract Failed Email Address:
In Thunderbird > 25-mail-delivery-failed
> select first failed email message
> locate failed email address
> select/copy to clipboard
⇑ 3. Update Membership Record:
In Updater Update window
> paste email address in Find… dialog
> click Find Next
> in matching member’s record > copy/delete email
> in Non-Del-Email paste email > enter fail date in date field
If more failed email addresses – ↻ Step 2
⇑ 4. End Task – Time-Out, close files:
In treasury.xlsx
> name-hours > enter Time-Out > save >close
> close/minimize other window as needed
☕ 🙂