2

Anyone out there use MX Notify Control? I am using the extension to send an email to a mailing list for a new channel entry.

It uses a standard template as the email, problem is I need to include an unsubscribe link in the template. Since it is not using a mailing list template I have no way to include a mailing list unsubscribe link.

Anyone know how you can create an unsubscribe link OUTSIDE of a mailing list template?

  • someone mentioned this but I can't seem to get it to work {exp:query sql="SELECT authcode FROM exp_mailing_list WHERE email = '{email}'"} DOMAIN.com/index.php?ACT=5&id;={authcode} {/exp:query} – Peter Eastwood Apr 30 '13 at 14:08
1

There is no tag for {unsubscribe_url} or {unsubscribe_link}.

As you are using the MX Notify Control extension and creating your own email notify template.

Within this template, you can try following SQL with query module to create unsubscribe link for an email:

{exp:query sql="SELECT exp_actions.action_id, exp_mailing_list.authcode FROM exp_mailing_list, exp_actions WHERE email='{mbr_email}' AND class='Mailinglist' AND method='unsubscribe'"}
<a href="{site_url}index.php?ACT={action_id}&id={authcode}">Unsubscribe</a>
{/exp:query}

You might need to update the {email_address} in WHERE condition.

I hope, it would help you.

| improve this answer | |
  • You are correct I am using using the MX Notify Control extension and creating my own email notify template. I tried your code and nothing appears in the email I am receiving. I tried {email_address} and {email} both did nothing. Any suggestions? – Peter Eastwood Apr 30 '13 at 18:00
  • {email_address} isn't any tag. I just put for example. Could you please try with {mbr_email}. I updated the query in my answer for the same. – Bhashkar Yadav Apr 30 '13 at 18:39
  • hmm still noting being sent in the email from the template. looking on phpmyadmin it looks like it should be 'email' I would attach a screenshot but not sure how to do it on here – Peter Eastwood Apr 30 '13 at 18:56
  • The template will be parsed for each email of mailing list to fetched the parsed template content into email message area and {mbr_email} should be replaced with that email. The query seems something fine to me. Let me check more so that we can find any prominent way. Also, could you confirm if you are using "Mailing List" module or MX Notify Control's plugin tag to save emails. – Bhashkar Yadav May 1 '13 at 1:45
  • 1
    MX Notify has the ability to send to a mailing list that is created in the EE Mailing List module. So all emails are being entered through the EE Mailing List module. – Peter Eastwood May 1 '13 at 11:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.