2025/01/05 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. The inserts 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 used for this task – excludes query button)
All buttons use the same parameters:
> Expire-Year as the fiscal-yyyy
> Low-Date as 4/24/yy (yy = current fiscal-yyyy-1)
…..Example: fiscal year is 2018 – Expire-Year = 2018; Low-Date = 4/24/17
Report 1 – Double click “Renewal – Inserts US-Donation-Yes”
> report-preview window opens
> note total pages in page-bar at bottom
> 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)-21.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 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 count
> attach the five .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
☕ 🙂