Snippets
Inserting an image into MembershipWorks emails:
<p><img src="https://anza.org.sg/assets/newsletter-header.jpg" alt="" width="600" height="96" /></p>
Inserting a menu into a sports page (remove the spaces directly inside the brackets):
[ insert page='athletics-menu' display='content' ]
This will display as follows:
Inserting a menu into a sports page (remove the spaces directly inside the brackets):
[ insert page='sponsored-content-tag' display='content' ]
This will display as follows:
- Sponsored Content
This is an Excel formula to convert MembershipWorks’ date format to an Excel date:
=DATE(RIGHT(BC2,4),(MONTH(DATEVALUE(LEFT(LEFT(BC2,FIND(",",BC2)-1),3)&" 1"))),(RIGHT(LEFT(BC2,FIND(",",BC2)-1),2)))This parses the date in BC2 which should be in the format ‘Mar 12, 2017’.
=DATE(RIGHT(P2,4),MONTH(DATEVALUE(LEFT(P2,3)&" 1")),RIGHT(LEFT(P2,6),2))
This parses the date in P2 which should be in the format ‘Mar 09 2008’.
These links take to you to the 3 reports