Usually not, and the reason is a billing limitation rather than a judgment about your prescription. Here is what compounded medications cost and how patients actually pay for them.
Distance is the wrong first question. Here is what to check before you hand a compounded prescription to any pharmacy, and when shipping beats driving.