Don't try to memorize a single rule that covers everything, because that's where most people get lost. "Por" and "para" each have several uses and they don't work as a simple swap. What does work is thinking about them by context: "para" points forward (where something is going, what it's for, who it's for), while "por" talks about the background (why it happened, what caused it to happen, through what medium).
Here comes the trick you probably haven't seen: when you're stuck, ask yourself if you can replace the preposition with "a fin de" (future purpose) or "debido a" (past reason). If it works with "a fin de", it's "para". If it works with "debido a", it's "por". Examples: "Te envío esto para que lo revises" = "Te envío esto a fin de que lo revises" → para. "No pude venir por la lluvia" = "No pude venir debido a la lluvia" → por. In your work emails, that quick test is going to save you a lot of time.
The detail most people forget is that "para" is also used with deadlines and time limits ("para el viernes tengo que terminar esto"), while "por" shows up when you're talking about duration or periods ("trabajé por tres horas"). So if you're writing about when something needs to be done, it's almost certainly "para". With a bit of practice using that "a fin de" versus "debido a" test, you're going to start feeling which one is right without thinking so much.