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:303834
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
