Personalized newsletter from template?
Question:
I am creating a 'make your own' newsletter function, where users can pick their own newsstories to include in their newsletter. The values of the newsstories they have picked will be stored in a database.
Can the Smart Mailer mail a template based on these values?
Answer:
You can make a page based on a URL parameter, for example userid, that displays the stories selected by this user from the database.
yourstories.asp?userid=1234
Next on the ASP page where you want to integrate the Smart Mailer, just specify this URL above as a template. Make sure the userid is filled with the real userid.
Comments
Using Request.QueryString
At wits end here and hope ANYONE (George, maybe?) can help me out. When I create a sql statement to pull all records from a table called Content and click submit, the entire table of articles is sent successfully to the recipient(s). BUT, when I use a dynamic sql statement for the edition date to pull records based on the date of edition for the newsletter I either get an error or I get sent an email with the newsletter template but no article(s) embedded.
I have tried everything but to no avail. I am asking anyone that can help me to please help -- do you want me to send a zipped file of what I have or maybe George (since I paid you for this extension :)) can help clear up the issue of passing a url parameter to the send page that pulls records based on date of edition.
You must me logged in to write a comment.