Auto-size/Scale up or down text to fit into text frame, NOT "fit frame to content"

[mnez]

Hi. I have a bunch of quotes (over 200) that vary in word length. When I do a data merge in InDesign, some of the text is cut off on some of the quotes.
How can I make the quote TEXT fit inside the text box, like auto resize the text to fit a specific frame size (NOT "fit frame to content")?
In other words, if there are too many words, the text will scale down in size to fit inside the box.

Thank you.

[brianp311 · Accepted solution]

This product will do it for you: 

 https://www.id-extras.com/products/fit-text-to-frame/

This topic has also been addressed and solved at various points in the forum's history. Try searching. The brute force solution relies on: 

while (myTextFrame.overflows) {
   myTextFrame.texts.everyItem().pointSize -= 0.5;
}

while there are more elegant solutions that include sorting algorithms.