Need help in tweaking VBA Macro

Hi ,

I have this VBA script from rondebruin . In summary this script looks at the column which has either "yes" or "no" and sends a mail to ppl whose column says "no"

Here is the example excel activeworksheet.

Name MailID Amount paid
vijey abc@gmail.ocm 100
Everon xyz@gmail.com 0

I wanted the script to send a mail to the person whose column reads 0. Only the Row of the person reading 0 will be sent to the particular person.


The code below is what i am trying to tweak and there is one line of interest here:--

ORIGINAL LINE

Please Login or Register  to view this content.

This line of code works fine but sends emails to each person irrespective of the column value.

TWEAKED LINE

Please Login or Register  to view this content.

This tweaked code is not working.

Can you please let me know how to tweak this line so that emails can be sent to only people with the triggered Column value.

Entire code:--

Please Login or Register  to view this content.

First administration: open forum rules http://www.excelforum.com/forum-rule...rum-rules.html , read about code tags and edit your post using it.

Now merit:

If this numerical value is in next column then try

Please Login or Register  to view this content.

is really mail in column B? the code looks like it checks column A ?

assumning column B for e-mails and C for values you coukd also try:

Please Login or Register  to view this content.