Calm down: this is a relatively small matter and does not seem related to what you have been doing and what you want to be doing.
Just send out an email stating that you have requested the transcript and it will be arriving late.
I would send what you have and also send out an email alerting them to the missing letter.
While they might not respond, I think you have good odds that they will read your email before then.