Votive Candles Posting

You are here:
< Back
  1. At the Windows desktop, delete EventPurchaseList.xls and if present, any other EventPurchaseList (1).xls, EventPurchaseList (2).xls, etc.
  2. If the Donorview page did not open, double click the Donorview icon and sign in if needed.
  3. In Events-Summary
    • at left, select Filter Name >Votive Candles
    • click on Actions >Export to Excel
    • close Donorview
  4. Back to the desktop, double click on EventPurchaseList.xls
    • click and drag mouse from A2 to E2 to select those cells
    • Ctrl-Shift-Down Arrow to select till last row
    • Ctrl-C to copy
    • close the Excel file
  5. Back to the desktop, double click on the Paste Intentions macro.
    • Yes to delete records
    • (But if it says “The command or action ‘DeleteRecord’ isn’t available“, click OK and Stop All Macros, and click on * on first row.)
    • Ctrl-V, and “Yes” to paste records
  6. At left, double click PUBLISH intentions macro
    • Click Yes when asked to replace existing files.
    • Notepad opens a file named INTENTIONS.txt. Remove extra spaces and line breaks, then Close and Save
  7. Switch on TV screen and select HDMI as source
  8. Mirror Chapel Tablet.
    • Pull down from top of Tablet >Play to
    • tap on SBWD
  9. Open Parrot Teleprompter.
    • Tap the play button.
    • If the latest list does not appear: tap on the gear on the lower right to open settings, then on the top left, tap “Sync with Dropbox“.
    • The font size may also be changed by tapping on the gear button (recommended size = 20).