This is not the tune PROVIDENCE written by Richard Terry, but out of the easily available choices, might be the best. The Terry is in the Songs of Praise hymnal the BBC has for its broadcasts. The Terry tune, like this one, should be public domain in the US.
The upper one is from a set of pages with this hymn at hymnary.org - not sure which it came out of, but 36 is from the 1940 hymnal of the Episcopal church - which is better than any of the mass-produced Catholic hymnals and being conservative episcopalian, almost everything in it is suitable for Roman Catholic use.
"By the Blood That Flowed From Thee," like "Lord for Tomorrow and Its Needs" (often captioned "Just for Today" in various hymnals, are both British in orign. "By the Blood..." originally appeared in Richardson's "Crown of Jesus Music", (London, 1857). The same melody appears in various editions of St. Basil's hymnals and in both versions (British and American) of Tozer's Catholic Church Hymanl. It also appears with a different melody in the St. Gregory Hymnal, although I much prefer the original melody. The melody and words Frogman posted are the ones I learned in school in Massachusetts.
"Lord for Tomorrow and Its Needs" was composed by Sister Mary Xavier, a Sister of Notre Dame (de Namur) of the Liverpool, England, province. Her secular name was Sybil Partridge. This hymn appears in various hymnals under different melodies. Check the later editions of St. Basil's and you'll see it there. It also appears in many Protestant hymnals (usually captioned "Just for Today" and excluding the verse about Purgatory), but lists the composer at Sybil Patridge, not her religious name. Sister Mary Xavier wrote the words and composed the melody "on the spot" while she was assigned to the bedside of a dying nun.
If anyone would like either melody, let me know; and I'll photocopy them for you.
The "Providence" melody by Terry is included in The Westminster Hymnal (London, 1953). It includes the original eight verses, including this one as the seventh verse: "In Purgatory's cleansing fires Brief be my stay; Oh, bid me, if to-day I die, Go home to-day."
Noel, #36 is not from the 1940; I suspect, from the typography, that it is from the 1916. (#36 in the 1940 is Greensleeves/What Child is this? in the neat modal version with the refrain beginning s s FI mi and the si throughout the verse.)
I was recently on a pilgrimage to Lisieux and wrote the attached words, which are based on a work by St Therese, to be sung to the R R Terry hymn 'Lord, for tomorrow'. My version is not great poetry, I'm afraid, but I offer it to anyone who might want a Therese hymn.
I wrote a simple arrangement of it last year with two violins, trumpet, and harpsichord/organ for a friend's school Christmas concert processional. If anyone wants the arrangement, send me a message.
To participate in the discussions on Catholic church music, sign in or register as a forum member, The forum is a project of the Church Music Association of America.