My HSG Nightmare

I went and had an HSG exam done yesterday and sadly found out that not only one, but both of my fallopian tubes are closed. Has anyone else gone through this absolute heartbreak? How did you make it through without crying every second of the day? Everyone has said, "God has a plan, and this is not final" but how can I feel better about this? I'm so miserable.