CHECKLISTS RESOURCES WHAT'S FOR DINNER COUPONS MANUFACTURERS
Banner Rotation: banners | banners (square) |
Products: create products | products | create product mapping to checklist | product/checklist mappings
Content: create recipe | recipes | recipe tags | content | checklists | restaurants | posts/discussions | replies/answers | users | categories | edit tags | resources | edit coupons
Email: template | mail engine
Manage: Social Link
 
Template
Parameters to include:
Criteria
Criteria Name
Enter SQL
 
Remove Bounced + Complaint Emails from the System
To prevent users from receiving additional emails, do the following:
(1) Copy/paste usp_removeEmail 'name@yahoo.com' into Word or another text editor such as Notepad
(2) Replace 'name@yahoo.com' with the actual email addresses to be removed. DO THIS FOR EACH EMAIL ADDRESS! If you have 3 email addresses to remove, your file should look like this:

        usp_removeEmail 'name1@yahoo.com'
        usp_removeEmail 'name2@yahoo.com'
        usp_removeEmail 'name3@yahoo.com'


(3) Copy/paste 1 line at a time into the large box labeled 'Enter Sql (Include all email Parameters in sql)'
(4) Click the 'Preview Sql' button. Verify the Newsletter1 value = 'False'
(5) Perform #3 and #4 for each email address to be removed.


          usp_removeEmail 'name@yahoo.com'

 
Test sending the Daily Dinner Email to yourselves
To send the Daily Dinner email to yourself, do the following:
(1) Select from the above 2 drop-downs as you usually do for 'Template' and 'Criteria'.
(2) Copy/paste the below into the 'Enter SQL' box.
(3) Click the 'Preview sql' button as you usually do.
(4) Click the 'Create Emails' button and you will receive the emails within a few minutes.


          usp_getDailyDinnerEmailList_DanGail


 
Send the Daily Dinner Newsletter Email
To send the Daily Dinner email to everyone who has subscribed, do the following (NOTE - the current max daily send per Amazon is 50,000 emails):
(1) Select from the above 2 drop-downs as you usually do for 'Template' and 'Criteria'.
(2) Copy/paste the below intoto the 'Enter SQL' box.
(3) Click the 'Preview sql' button as you usually do.
(4) Click the 'Create Emails' button and users will start to receive the emails within a few minutes.


          usp_getDailyDinnerEmailList