This thread on Herb Alpert & the Tijuana Brass (which, as it turns out, had not so much Tijuana but plenty of brass) got me to thinking about songs of that era with prominent trumpet parts. I just listened to Alone Again Or, by Love, which has a lovely trumpet solo in addition to gorgeous acoustic guitar and other strings.
Besides the Tijuana Brass catalog and Alone Again Or, what other songs of the late '60s (or anytime, I guess) feature prominent trumpets?
Blood, Sweat and Tears
Pretty much anything from the entire Stax/Volt catalogue thanks to the Memphis Horns.
Touch Me by the Doors if you are thinking more rock, less soul
Not a big fan, but Chicago fits the bill
That’s a lot of albums.
I thought I was the only one who saw a similarity between Herb Alpert’s work and “Alone Again Or.” 
One year late, but Ides of March’s “Vehicle” has trumpet, and another year later, “Get it On” by Chase- at least I think these have trumpets- I’m not good with my instrument recognition.
… and I should have mentioned A&M’s Sergio Mendes and Brasil '66 in the OT, whose trumpet-heavy Look of Love is probably my favorite version. Thanks for the other recommendations.
WreckingCrew and silenus: Ignorance is fought once again. I’d heard of the Memphis Horns, but … Holy. Cow. That’s a **lot ** of hit records – I’m probably not the first to say they’re the Funk Brothers of Stax/Volt.
Chicago. (Ooop, now I see WreckingCrew got it)
Man, I loves me some Herb, especially Whipped Cream and Other Delights.
“Penny Lane” (by the Beatles) is what immediately springs to mind.
Most of James Brown’s singles during this period prominently feature trumpets.
Jugband Blues by Pink Floyd off of A Saucerful of Secrets features a Salvation Army band. It sounds like there’s a trumpet in there somewhere.
Well, they are half of the Funk Brothers of Stax/Volt - the other half being Booker T and the MGs for your guitar/bass/drum/organ needs.
Blood Sweat and Tears – both the original incarnation and the watered down David Clayton-Thomas version – used horns extensively. “House in the Country” from the original groups Child is Father to the Man has a particularly good horn part.
Spirit’s “Mr. Skin” from The Twelve Dreams of Dr. Sardonicus has a nice horn section, provided by Tower of Power, whose horn section was almost as busy as the Memphis Horns.
There were a spate of groups that came along around the same time, all featuring horn sections.
Blood, Sweat & Tears and Chicago have already been mentioned, but also The Ides of March, Pacific Gas & Electric, Delaney & Bonnie, and the Electric Flag.
“Got to Get You Into My Life” by the Beatles came immediately to mind.
Getting away from the brassy horn section sound, how 'bout “Raindrops Keep Falling on My Head”?
Good call. Burt Bacharach/Hal David compositions in general (most notably those performed by Dionne Warwick) featured those mellow horns.
Johnny Cash’s “Ring of Fire”
Really? I’m remembering Fred Wesley on trombone with the JB’s but I can’t conjure up any trumpets…
How about Stevie Wonder? “Sir Duke”, “Superstition” come to mind.
The big studio band on the Fifth Dimension records featured horns prominently, as on “Sweet Blindness,” "Wedding Bell Blues, “Stoned Soul Picnic,” “Aquarius / Let The Sunshine In” and others. Other records off the top of my head are “Timothy” by The Buoys, “Are You Old Enough” and “Arizona” by Mark Lindsay, “Life Is A Carnival” by The Band, “Polk Salad Annie” by Tony Joe White, “Don’t Say You Don’t Remember” by Beverly Bremers, "Nothing But A Heartache’ by The Flirtations. Sly & The Family Stone had its own horn section, featured on "I Want To Take You Higher, “Thank You (Falettinme Be Mice Elf Agin)” and others.
“Get It On” by Bill Chase
Technically released in the 70’s, but I think we call all agree that the 1st couple of years in the 70’s should be classed as a part of the 60’s music scene.