• Post Reply Bookmark Topic Watch Topic
  • New Topic

mailing Newsletter to all Subscribers  RSS feed

 
Ganesh Phapale
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a requirement for sending newsletters (HTML fromatted mails) to subscribers.

I have to pick up the email ids from database and send the newsletter.

but I can't do it in a simple
while (rs.next())
loop till all r not finished.

since I am having Large number of entries in database (arround 3-4 Lacks)
if many of them bounces back then it will cause my server to crash down.

and also there is a issue of getting my server declared to be sending spam by mailservers like Yahoo,Hotmail,etc..
and all the mails wil get blocked.



therefore I need to track mails which are bounced back and remove those entries from database.
can anybody suggest the best approach of doing so??

pls help!
 
Carol Enderlin
drifter
Ranch Hand
Posts: 1364
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was going to suggest that you scroll down in this forum because someone else recently asked about how to handle bounced emails and got some responses, but it was your previous post.
 
Ganesh Phapale
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi !
I had posted the same kind of query but I have not recieved satisfactory answer.
If somebody has faced such a kind of problem pls help me.

thanx in advance...
 
Rachel Swailes
Ranch Hand
Posts: 434
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you did not get a satisfactory answer about a post, then it is probably because there is no one in this forum who has the ability to answer the question in any more detail. I for one read the response that you received and it looks like a satisfactory answer that there is no way that you can guarentee that you will receive a failure notice.

If getting a large amount of emails back is causing your server to crash then maybe you need to investigate why your server crashes. Is this crash java related or simply because your server cannot handle the load?

Rachel
 
Carol Enderlin
drifter
Ranch Hand
Posts: 1364
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I do not see a response from you to your previous post that the answer was not satisfactory and why.
 
Ganesh Phapale
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi !
Regarding my previous post replies I didn't got satisfactory answer b'coz
in the Jakarta Commons mails also the setbouncedaddress method sets the adress to that of the from field adress
and
Since my Database is huge and the bounced mails are in large amount, causes the mail account (eg. support@abc.com , from where I send the mails) to get full in turn causing the server to crash.

though I limit the Number of mails sent daily to a small figure to avoid above mentioned problem
The another problems still persists
>> How do I get the email ids of the bounced mails and remove them from my database , since bounced mails are coming on the some account may be instantly or after some amount of time?
How do I read those emails ?
How do i stimulate my code when i get the bounced mail?

???
 
Rachel Swailes
Ranch Hand
Posts: 434
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you can have a set bounce address, then why not direct bounced emails to another address such as unsubscribe@abc.com That way when emails arrive at this address, you can have code to process them for the address and remove this address from the database.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

How do I read those emails ?
How do i stimulate my code when i get the bounced mail?

The problem is how do you know an email you receive is a notification of a delivery failure. As I pointed out last time you posted this, there are no SMTP reply codes which indicate deliver failure because an address does not exist. You can read the RFC to confirm this if you like.

The closest you can get with SMTP is a user defined field. The problem is that it is user defined, not standard. Looking at our company's SMTP server, it seems to generate an "X-Postfix" header which a delivery failure message. So if I knew that every email sent from my server goes to a server of the same type, I could parse the headers of all received messages to spot these failures. However as soon as a message goes to a different server type, I can't guarentee this header will be in the message.

You could also try to parse the email's subject - many servers include something like "Undelivered Mail Returned to Sender" as a subject. This isn't a cast iron route though, becuse what subject the server uses is up to the server's specific configuration and there is no requirement in SMTP to even send a delivery failure message.

You could also write a Transport implementation for whichever server you are using which gives more functionality than is defined in SMTP. This way you could interpret problems such as invalid domains. But you still couldn't guarentee any info on nonexistant users in an existing domain.

You could also check your address domains by trying to connect to them before sending any email - using java.net.*. This would give you a quick test to see if domains are invalid. But of course you'd have to write this carefully, since domains may be temporarily unavailable.
[ February 23, 2005: Message edited by: Paul Sturrock ]
 
Ganesh Phapale
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanx for ur replies..

I got ur idea but can you please give some hints in coding to get access to INBOX on my mailserver inorder to parse the mails.
pls help



there is another problem (from my earlier post)
==============================
also there is a issue of getting my server declared to be sending spam by mailservers like Yahoo,Hotmail,etc..
and all the mails wil get blocked !!!
==============================

>>Is there any limit on sending the mails to mailservers such as Yahoo,Hotmail,..?

>>There are desktop softwares for sending bulk messages which uses the tricks of altering SMTP IP addresses, introducing delays after some intervals, altering from accounts etc...

I have to yet try this option

is there any other alternative???
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

also there is a issue of getting my server declared to be sending spam by mailservers like Yahoo,Hotmail,etc..
and all the mails wil get blocked !!!

More likely in the case of Hotmail and Yahoo than the volume of mail you send to hotmail or yahoo addresses is the number of recipients who report it as spam (i.e. they don't want to receive your newsletter). As I understand it sending mail to non-existant yahoo/hotmail addresses means you will turn up in their auditing and may get blocked. But since you say your newsletter is subscription based, this shouldn't be too much of a problem, so long as you its an opt-in newsletter, rather than an opt-out one, and you have some semi-regular auditing method. For example, many newsletter style emails I receive periodically send out "do you want to continue receiving this" messages. I assume there is some process which parses responses if I reply, and removes my details if I don't.

As for accessing your inbox, look at com.sun.mail.pop3.*
 
Ganesh Phapale
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i.e. problem will not arise as far as the mails are delivered and not bounced.

but still what to do when the list is in Lacs and bouncing per% above 25%

searching out for automated bounced mail handlers..
:roll:
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!