unable to change range in code

[fabrecass]

hi guys,

the code below sends an email to a fixed recipient when a date has passed (column L) and another cell is blank (column M), however, it sends an email for every row on the table, i need just one email, so if M2 is blank, i need 1 email sent.

Now i didn't write this code, and i only half understand it - but i figured if i shortened the range it looked at (ie change l65536 to l2), then perhaps it would only check the first line of data and therefore only send 1 email - however when i do this, instead of sending loads of emails, it doesn't send any....

can anyone help?

Please Login or Register  to view this content.

[RHCPgergo]

The loop in the macro starts from 13 and ends at the row number of the last row with data in column L.

So if you want to just have one row (row #13), change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

edit: there seem to be some illogical references in your code, but if it works, why change it I guess...

[OllieB]

fabrecass,

I have tried to simplify the code a bot (just removed what was not used), so the following code should do what you want it do

Please Login or Register  to view this content.

[fabrecass]

thanks guys, both answers solved my issue, i've used your code OllieB and it's fantastic! thank you so much!

[OllieB]

thanks guys, both answers solved my issue, i've used your code OllieB and it's fantastic! thank you so much!

You are very welcome. Please remember to mark your thread as SOLVED and click the star icon if you are happy with my contribution!