2025/04/04 update
Office Page Links
This TJ45 task prints inserts for Tprint members
(pkagaaer inserts)
This task is done about the time that the pdfaaer is sent to the printer. Inserts are the printed sheets for pkagaaers and contain print and adv type member renewal requirements, mailing address (shows through the envelope window), and other information. Depending on a given file’s count, some files are printed locally and some are sent-to and printed-by FedEx Office. This task creates five different reports as PDF files using five Report Window buttons:
- Renewal – Inserts US-Donation-Yes (current expires)
- Renewal – Inserts US-Donation-No (current expires)
- Future – Inserts US-Donation-Yes
- Future – Inserts US-Donation-No
- Adv – Inserts
⇓ 1. Start Task – Time-In, open files:
⇓ 2. Run/Save Reports to PDF’s:
⇓ 3. Print Reports via Fedex Office:
⇓ 4. End Task – Time-Out, close files:
⇑ 1. Start Task – Time-In, open files:
At treasury.xlsx
> in name-hours > enter Date, Task = TJ45, Time-In
Open D:\fmaatc\publish-Tprint
> add sub-folder yyyy-Tprint-inserts (yyyy = fiscal year)
…..this folder is for five report PDF files produce in this TJ45 task.
Open membership.accdb
> click Report button in Switchboard window (the Report window opens)
⇑ 2. Run/Save Reports to PDF’s:
The buttons for these reports are on the left side of the window in the “Publish Double A’er” box
…(ten buttons – bottom five are used for this task – excludes query button)
Buttons parameters:
> For Renewal… buttons – Expire-Year = fiscal-yyyy
> For Futures… buttons – Expire-Year = fiscal-yyyy+1
Report 1 – Double click “Renewal – Inserts US-Donation-Yes”
> report-preview window opens
> note total pages in page-bar at bottom
Print on local printer if count is about 40 or less > click “Print” (tool ribbon on left)
Otherwise > click “PDF…..” (tool ribbon Data > PDF…..)
> Publish as PDF….. window opens
> add the total pages to the end of the file name. Example: rptFut(US-Dyes)-88.pdf
> navigate to folder D:\fmaatc\publish-Tprint\yyyy-Tprint-inserts
….note yyyy = fiscal year you entered at the start of this task
> click Publish (the .pdf file is written to the selected folder)
> Export – PDF dialog displays > Close
> click “Close Print Preview” > Report Window displays
Report 2—5 – Follow Report 1 steps but using the other buttons.
⇑ 3. Print Reports via Fedex Office:
At Thunderbird > FMAATC… > Inbox > TJ-publication > TJ45-Fedex-Office
> select/copy content of “TJ45-text”
> click Write
> paste text into email body
> ctrl+x URL > paste in To: field
> ctrl+x subject > paste in Subject: field
> take snapshot of files to be attached
> replace snapshot
> update number of files and count
> attach the .pdf files – drag and drop works good to accomplish this
> “Copy message to:” field must be “TJ45-Fedex-Office on fmaatc.org@gamil.com”
> send message – wait for “Sending Message” window to complete
> receive email from FedEx – printing completed (may require a phone call)
> pickup at FedEx Office at 2616 Baseline Rd.; Boulder, CO 89305; 303-494-2622
> printed pages to be used when preparing the pkagaaers
⇑ 4. End Task – Time-Out, close files:
In treasury.xlsx
> in name-hours > enter Time-Out > save > close
> minimize/close windows opened as needed
☕ 🙂