You have questions and so do we.
The idea can work but in order to help we need sone details
Are the mailboxes inside of a building?
If yes then what are the walls made from?
Can you add an antenna? Even a small one?
If you want to transmit when the door is open you may need to put a receiver so it can see the door.
It could act like a mesh network.