Thank you Kyle,
In our particular use, all new members are approved by the site owner, with many subscribers being rejected.
In our registration confirmation email, which sends out the email confirmation link, we've added a couple of questions for new subscribers to answer. Most people answer right away, but 2 other things happen, 1- they don't answer, even after receiving the email and clicking on the verification link, and 2- they never get the email because of their spam blockers, etc. (for some reason this happens a lot with German ISP emails).
As the site owner has to follow up on these cases, the easiest option is to forward the email with the confirmation link and ask them to answer. Unfortunately, for those who's email got blocked by their ISP, it will get blocked again if I use the "Resend Confirmation".
The Auto Actions are a solution if I can include a confirmation link, otherwise I could customize the emails to the moderator to include the custom text and email confirmation, if that's possible.
Tomás