Don't give up on your dream. Believe me, I know it can be hard to keep pushing forward, but the struggle is part of the process.
Even if you are still not achieving success, others are watching—and they are appreciating that you are still striving. You probably don't realize it, but you are a role model. Believe that your efforts will pay off. Keep doing the next thing that will bring you closer to your dream, and don't let rejection hold you back.
I saw a cool quote that might inspire you:
So, with that thought, I should be very proud of myself. (I've gotten quite a few rejections.)
I heard a song last year whose wistful melody is encouraging. The song is Don't You Let Go by The Brilliance. Give yourself two minutes and listen to it. One line is particularly personal to me: "Though I'm as tired as I've ever been, I'm not giving up the fight . . . I won't let go of my dream."
Whatever you do, work at it with all your heart, as working for the Lord, not for human masters. Colossians 3:23
Remember, perseverance matters! Write on, friends!