fin
|
| Posted: 03/07/2002, 3:56 PM |
|
HI - my first post so excuse me if this is a dumb question!!
The Problem
I am still trying out CC and how it can help with my workload - one of the functionality issues I have to create is as follows:
When users register to the site they select upto 3 (at least one) records from a list of newsletters to subscribe to.
On a weekly basis an email is sent to all users containing all new records for the newsletters they have subscribed to. So if a user has asked to receive info on newsletter A and C, he gets all of the last 7 days new records for both, in one mail.
I have used thegotocode example and changed the main newsletter page so that all newsletters are auto-checked, and the mail list is created / sent BUT
.....This is where I get lost
Before the mail is sent, how do I insert into each individual mail's Body these details.
sample of my db below
User table Newsletters
UserID NewsletterID
News-choiceA (linked in DB to NewsletterID) NewsletterDesc
News-choiceB (") NewsDate
News-choiceC (") NewsInfo
I know this might be obvious, but I can only see unique user registration mail examples, or multiple newsletter to multiple members examples, BUT no multiple newsletters to multiple members with multiple possible email content.
As you can tell I have been playing with this for too long and hence why I am rambling and probably losing / repeating myself.
Anyway your help would be GREAT!!!!!!!!!!!!!!!
andrew@andrewfinlay.com
System Being Used
I am uning CC, ASP with templates, Win2k+IIS+CDONTS+Access database.
|
|
|
 |
fin
|
| Posted: 03/07/2002, 4:21 PM |
|
also.....
just re-read above
i suppose the best description of above could also be to create an autofilled form which equals the content section of the mail.
|
|
|
|
Damian Small
|
| Posted: 03/07/2002, 10:09 PM |
|
With the help of the Tell-a-friend example and some other assistance off this forum I generated a strBody that contains a header with dynamic data as in the example. I also have concatenated to the strbody a loop that iterates through a shopping list of items. A similar loop could be used for the mail list. ASP templates Win2K+IIS+CDONTS anyone interested drop me a line.
Maybe I can put something back.
Regards Damian Small
dsmall@idx.com.au
|
|
|
|
Nicole
|
| Posted: 03/11/2002, 2:38 AM |
|
Fin,
the solution depends on db structure and table relationship.
The one approach is to run through whole users table and check for userID in Newsletters table the same to userID currently selected from users table. If they are match each other the mail is to be sent. To fill mail body you should select proper fields from newsletters table. Try to use dLookUp() function for this purpose.
If you provide tables structure and description what fields are to be in mail body I'll be able to provide more detailed description.
|
|
|
|
|
