[SOLVED] Resend confirmation link with acymailing

I would like to use AcyMailing to create customized email that contains the CB activation link for users who havent confirmed yet their account.

With AcyMailing I can create a mass action ti filter users non confirmed and then use a CRON to automatically send reminders.

My problem is: how can I put the CB confirmation link for every user in the email sent by AcyMailing? Is there a way?

If you've access to substitutions in AcyMailing then you'd use the below. Otherwise you'll need a way to grab the cbactivation column from the _comprofiler table for the user being sent the email.

index.php?option=com_comprofiler&view=confirm&confirmcode=[cbactivation]

I've found in the AcyMailing "Tags" for CB a tag that I suppose I should use for this purpose:

{cbtag:cbactivation|info:receiver}

This is the code it generates automatically when I insert the Acy Tag in the newsletter.

This link worked: /index.php?option=com_comprofiler&view=confirm&confirmcode={cbtag:cbactivation|info:receiver}