Example Data from Mysql
To make this a little clearer. The page template / content is stored in mysql and is fetched by a recordset in the page sending the email. In UE it is inserted ino the Email Message Body Editor using the dynamic lightening bolt and the value in the Email Message Body Editor looks like this...
<?php echo $row_rsContent['htmlcontent']?>
Which then pulls data from the recordset/mysql table/column which looks like this below. And, for example I wish to be able to place the readerid on the "Click Here if you are unable to view this email properly" link.
<head>
<title>January Campaign One</title>
</head>
<body bottommargin="0" topmargin="5px" leftmargin="0" rightmargin="0" bgcolor="#000000">
<table border="0" align="center" cellpadding="0" cellspacing="0" width="100%" bgcolor="#000000">
<tr>
<td bgcolor="#000024"><table width="600" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="600" align="center" style="padding-top:5px; padding-bottom:10px; font-family:Verdana, Geneva, sans-serif; font-size:12px;"><a href="#?readerid=<?php echo $row_rsRecipients['readerid']); ?>" style="color:#FFF">Click Here if you are unable to view this email properly</a></td>
</tr>
</table>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td align="center" bgcolor="#FF0000" style="padding:15px 0px 15px 0px;font-family:Verdana,Arial;font-size:12px;font-weight:bold;color:#FFFFFF">SAVINGS ON LOTS OF PRODUCTS THROUGHOUT JANUARY 2011 VISIT WEBSITE</td>
</tr>
<tr>
<td align="left" bgcolor="#FFFFFF" style="padding:5px 0px 10px 0px;font-family:Verdana,Arial;font-size:11px;line-height:16px;font-weight:regular;color:#231f20; text-align:center">My Business Address</td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
Does this make it a little clearer...any help appreciated!
PS in the a link there is a #. This is for this post...the real email contains an absolute URL instead.
PSS As you can also see there are two recordsets on the page rsContent that gets the content for the page and rsRecipients which gets the id and email for each recipients. These two recordsets are available on the page sending the email.
