yep..sepearte tables to hold memberID and mailing ID is great (if you have mailings set up in the DB that is).
Which way to go depends on how much complexity you want and if you needa long term history of who got what and when ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Lawrence Ng" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 16, 2004 1:21 PM Subject: RE: Need Suggestions for Spreading Out Notification Mailings >I agree with Dov. that's exactly how I did mine as well for my former > employers... we had to send out over 22K invites and I batched them over > a period of 2 to 3 weeks. I used a combination of tables and scheduling > functions to keep track of what has and not been sent out. Be careful > too with the spooling and don't do too much. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184484 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54