No, If you activate a user manually, the user will not receive a notifying email.