Loop through rows and send mail with incremented details each time criteria is met.

[ANDREAAS]

Good Day All

I have some code from @RonDeBruin that is adapted to work for my specific purposes, however i do not know how to make it loop through the rows and increment the ranges each time the criteria is met.

Unfortunately my file is too big to upload,but here is the details and the code.

The criteria is "YES" in Column O
So, each time "Yes" is found in Column O, The highlighted sections in the code needs to increment to the row number corresponding where the "YES" was found.
Each time "Yes" is found needs to produce a new mail.

Please Login or Register  to view this content.

Thanks in advance for any help.

[maniacb]

I recently made similar changes using the information at this link https://www.excelforum.com/excel-pro...ook-email.html. Links to source pages are included. Cheers

[ANDREAAS]

thank you @maniacb, but this is a completely different scenario. The code above already sources and sends the data to mail. What i need is a loop that will increment the code values to suit where the criteria is found. thank you for trying to assist though.

[ANDREAAS]

any ideas anyone?

[oeldere]

Please do not PM me.

Hi

I see that you are having a loop at my thread https://www.excelforum.com/excel-pro...ia-is-met.html
would you be able to assist in any way please.

If you post on the forum you have the reach of all forummembers.

[AliGW]

Administrative Note:

Andreaas - you have been a member here for a long time and should know that messaging other members asking them to help with your issues is not allowed. Unfortunately, you have violated Rule #8 of our Forum RULES:

Don't private message, visitor message or email Excel (or Access, Word, etc.) questions to moderators or other members.

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to a permanent ban, so do take this caution to heart.

[oeldere]

Since this is an open forum, I share this comment with the other forummembers.


Alltough it is allowed to give a negative rep, I want to share that I received a negative rep.

Thread: Loop through rows and...

no need to be nasty, i just noticed that you were looking at this thread while i was browsing

[ANDREAAS]

very mature.

[ANDREAAS]

AliGW

The intent was not for the member to help in private away from this thread. The member was actively looking at the thread at that time and i asked if he/she would be able to assist with the thread, i did not ask to be helped in private where it would not benefit the community, but to get nasty about it from the member and then acting immature about negative rep in response to being nasty is an issue.

Rule #8 was never broken. I did not message any excel, access or word question. I asked if the person looking at the thread would help with that specific thread that he/she was browsing.

[AliGW]

The reason that what you did is not allowed is to protect members, particularly those who are very active here, from a barrage of visitor and private messages prompting them to look at threads. As I am sure you will realise, if you look at it the other way around, this would very quickly become unmanageable with members’ mailboxes filling up with requests like yours. That’s why it’s not allowed. There is no way to fast track a resolution to your problem: you just have to be patient. Sorry.

[oeldere]

@ANDREAAS

If I look at a question, I explore if I could provide a solution.

If not, I will not answer.

How about a lot of members adding to your question, they don't have an anser for you.

Would that be helpfull for you?