ODesk Assignment No.1: Emailing tons of News Letters every month.

Assignment:

1)Send a HTML based News Letter to client's customers that is currently about 2,500. in the future it would increase to over 10,000.
2)If we will get bounced backs, put them into a list and eventually make a bounced back list.

My approach:

1) Write a java based software to send them all automatically(like,,,Read recipient's email from Excel and send news letter to it automatically.)So that nobody will get involved in routine, monotonous, and repetitive work! The email addresses are loaded from provided excel file.
2)If we have gotten bounced back, it will change the background color of particular cell where email address is put in excel file.
3)==>02.02.08:SMTP server we have used set Daily Sending Quota on our account,we are not sure it is set initially or set in between, we could send out only limited number about 500 in gmail, 250 in our DSL provider account. All we have to do in this talk is sending out 10,000 mail as soon as possible.
we decided to use 6 or 7 DSL provided account to send out.Each set 250 limitation, we could only send out 1,500(6*250) per day, we need 7 days to complete 10,000 sending(7*1,500=10,500).Software obviously need to be extended to handle this specific situation
(Since we have been using DSL smtp server, the limitation setting on our accounts is out of our hand unless we have our own SMTP server..) So we need some feature for solving this problem.My basic idea is An user can type and save a valid DSL account info as many as possible they can and when we launch software, it loads that account info file and keeps in (its memory space.) and picks up by ordering in a file and uses it for sending out, IF the specific exception occurs that is of cource "Daily sending quota exceeded", changes DSL account from an account that already exceeds daily quota and continue sending.
Software will stop only when there is no more valid DSL account in a file.
4)==>27.02.08: We need to extend our software to have "forward" feature. and only differences between "forward" and our new feature are we need to correct "subject" and address in "To".

"Be effective!"

Issues&Solutions

Issue1:
Error I got from Gmail ==> Daily sending quota exceeded
----
Exception in thread "main" com.sun.mail.smtp.SMTPSendFailedException: 550 5.4.5 Daily sending quota exceeded. f55sm8668781pyh.28
----

Solution1:
1.Search result of this quiery(Daily sending quota exceeded)

(We haven't gotten any solution yet, so my alternative way is to use ISP provided mail account to send news letter out..
Or we will stand with that mail quota limit and send a few hundreds mails day by day till complete sending all.)
==>27.02.08:we discussed and decided to use several ISP provided accounts, let's say, for example use 6 ISP accounts which every account restricted with daily quota limit about only 250 mails per day, but in total we could send out 1,500(6 * 250) mails per day.also decided not to use gmail because gmail smtp server eventually gives our mail back with uncertain error(PERM_FAILURE)...We tried and looked for a solution for it but nothing gives

Issue2:
PERM_FAILURE:SMTP Error (state 13): 550
Suddenly I got baunce backs mail from most of recipients that sent my newsletter to using Gmail account, they actually didn't create any problem last month emailing newsletter...
So I got to find the reason and its solution for proceeding my emailing task..

Solution2:
1.Search result of this quiery(SMTP Error (state 13): 550)

(We haven't gotten any idea to solve this yet)
==>27.02.08:we gave up using gmail account for sending our newsletter out.

Issue3:
The contents of the News letter is made using MS-word and is sent using MS-word feature that is you can select "send to" option from File menu or sort of it. This is the way a HTML news letter made. But Due to MS-Word HTML generator is not well-performed enough, when we try and get an original HTML code from a HTML newsletter, HTML code is broken. This fact leads another problem that is the allighment and format of our newsletter sent by our software are collapsed.
So I need to skip one thing that is parsing a newsletter into HTML code.
and directly send a newsletter without parsing it or getting an original HTML code from a newsletter.

(current procedure)
1.receive a HTML newsletter sent through MS-word.
2.parsing it into HTML code using ,for example if you use gmail "show original" option from option menu in gmail.(<==this step should be skipped.) 3.copy and paste HTML code in our software. 4.send out (<==No.3&4 steps should be skipped.because it collupses HTML format&allingmen.)

(required procedure)
1.receive a HTML newsletter sent through MS-word.
2.send out recieved mail just as it is, only correct "subject" and address in "To".
it is almost same feature of "forward" function.

Solution3:
1.Search result of this quiery(SMTP Error (state 13): 550)

(We haven't gotten any idea to solve this yet)
==>27.02.08:we gave up using gmail account for sending our newsletter out.

Other errors I've gotten:
1. javax.mail.AuthenticationFailedException: Your mail spool lock busy.

References:

Javamail Instructions:
Here is the page describes how to build a desktop application using Javamail API and instructions.
+ Auto-email Javamail desktop application

POI Instructions:

Here is the page describes how to integreate Apache POI package into the Javamail desktop application.

Log4J Instructions:
A open source software Log4j gives you informative logs with significantly easy configuration and implementation.All you have to do is a very little of configuration and quite similar implementation way like print out method bundled with Core Java API.
+ Log4J instruction explained here