Macro to re-send emails using Outlook

Hello Everyone:

Looking at a VBA script example code from Mr. Ron's website (www.http://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 you 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 timestamp 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 like 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"?

Rather there 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.

Best regards,

Zain

You may download the excel spreadsheet from the link below

http://uploading.com/files/38fd545d/...iewees_z.xlsm/

Hi zainnofear1987

Change these two lines of code to prevent this

In the current code, it is resending all candidates again

from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.