AN OPENED EMAILS REPORT VIEWER - Nov 16th, 2012


Assuming that you have a first_name’, a last_name’, and an 'opened' check box field in your table, here’s a
simple viewer that will list the recipients of emails that were opened and when they were opened, those recipients that
did not appear to open their emails, and an email list to contact them.


<span class="your_heading_class">THESE EMAILS WERE OPENED</span>
<?php foreach ($your_tableRecords as $record): ?>
<?php if ($record['opened']==1):?>
<span class="your_body_class">
<?php echo @date("l F jS, Y - g:i a", strtotime($record['updatedDate'])) ?> - <?php echo $record['last_name'] ?>, <?php
echo $record['first_name'] ?>
</span>
<?php endif ?>
<?php endforeach ?>
<hr />
<span class="your_heading_class">THESE EMAILS WERE NOT OPENED</span>
<?php foreach ($your_tableRecords as $record): ?>
<?php if ($record['opened']==0):?>
<span class="your_body_class">
<?php echo $record['last_name'] ?>, <?php echo $record['first_name'] ?>
</span>
<?php endif ?>
<?php endforeach ?>
<hr />
<span class="your_heading_class">EMAIL LIST FOR EMAILS THAT WERE NOT OPENED</span>
<?php foreach ($your_tableRecords as $record): ?>
<?php if ($record['opened']==0):?>
<span class="your_body_class"><?php echo $record['email'] ?>;&nbsp;</span>
<?php endif ?>
<?php endforeach ?>



The materials on this web site have been created for use with CMS Builder content management software. CMS Builder software is published and licensed for use by InteractiveTools.com. Please contact Interactive Tools for information on the downloading of the software or the purchasing of licenses.


Terms of Service