Mark Evanier has had an ongoing series about writers and rejection some of whose columns apply very well to actors and other creatives.
The most recent one, however, goes deeper into the notion of writing for pay and how one might go about it from his experience. Check it out.