Anybody have any advice? Not looking for code samples, just advice on grouping email blasts by domain to minimize the number of SMTP connections.
Would the CFMAIL GROUP attribute help? Should I loop over my userbase by top level domain and chunk it out that way? Mik At 03:37 PM 4/20/2008, Michael Muller wrote: >I've been having trouble sending opt-in posts to a local university. They cite >that each post on my website results in 250 unique smtp sessions to their mail >server, and that they'd prefer one session per post. This is a reasonable >request, and would probably help with Yahoo and AOL, as well as possibly even >ease the burden on my mailserver. > >So, what would the best way be to accomplish this? How can I create a single >email per domain and BCC all users there? > >Currently I run a query that pulls all the email addresses destined for >delivery, and use the QUERY attribute of CFMAIL to deliver individual emails. > >Should I create a new field in the [USER] table that contains the TLD of each >user's email address, and then either do a GROUP BY in my SQL query, or a >GROUP in the CFMAIL tag on that column? > >If I do a query GROUP BY that'll essentially create a sub-list of email >addresses to send BCC: within a single email. I think. > >If I do an email GROUP that'll ... hmmm... send everyone a mutiple-layered >email based on the number of addresses at the grouped domain? ie; if there are >ten people with an AOL.com address, and I used CFMAIL GROUP="tld" then the >resulting email will go TO: all AOL.com addresses, with a stacked email >showing the same thing ten times? > >Any advice? Is there a better way? > >Mik > > >--------- > > From LiveDocs: > > Group > Optional > CurrentRow > Query column to use when you group sets of records to send as a > message. For example, to send a set of billing statements to a customer, > group on "Customer_ID." Case-sensitive. Eliminates adjacent duplicates when > data is sorted by the specified field. > > > > >-------- >Michael Muller >Muller Technologies >24 3rd Street >Turners Falls, MA 01376 >work: (413) 863-0030 >cell: (413) 320-5336 >skype: michaelBmuller >http://support.MullerTech.com > >Information is not knowledge >Knowlege is not wisdom > >Eschew Obfuscation > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
