Looking at Mr. Ron's VBA script examples (http://www.rondebruin.nl), I modified one accordingly
for one of my office work.
I am a recruiter for a company and maintain a database of all candidates in excel. Every time a candidate gets accepted or
rejected, I have to send him an e-mail of acceptance or rejection. To avoid the repetitive task of manually logging in and
typing the text, I thought of making my life easy by working on excel macros.
I would be very thankful if someone
may have a look at the spreadsheet I created. I would like you to modify the code a bit if you can spare some time for me
in the following manner.
1)I created a list box in column "I" for status. If you select Accept, it sends an
acceptance e-mail which is shown in column J along with a time-stamp in column K.
Same thing happens if you select Reject in Status (I column).
The first option in the drop down menu is a BLANK
value, incase I do not want to send any emails to particular candidates.
Now what I would is if I add more rows
for candidates and want to send an email to only those, how can that be done?
In the current code, it is resending all candidates again.
Is it possible to add a dialogue box which would ask
the user :- Would you like to resend "acceptance" or "rejection" email [depending on what you selected in column J] to
[persons name] from column A?"
If selected "yes" then resend the email, if selected "no" then do not do anything
and proceed to the next row. It would be great to have an additional button of "NO TO ALL" along with "Yes: or "No".
Suppose I had earlier sent emails to 30 candidates and added only a few candidates at the end of the sheet. Now if I
only want to send email to those new ones, if we run the code, I do not want to click 30 times on "No" button when I get a
pop up which says " Would you like to resend " acceptance" or rejection email to "XYZ" candidate"?
should be a button of "No to all" by which it sends email only to the newly added candidates and doesnt ask me to resend
email to the above already sent candidates.
I would be very thankful if you can help me.