email some but not all from data in excel

[Tony_Page2711]

I have data in excel and one of the columns includes email addresses. A further column includes a "Yes" if that column heading applies to that person but is blank if it doesn't, i.e., the column heading refers to a sports fixture against the club at the top of the column. If person A is selected, he would have a "Yes" in the column under that fixture; if not, it would be blank. Each row has the person's email address in one of the columns. How do I send the same email to all of those selected but not to the others? For instance, the identical email will contain information that they have been selected plus all the details associated with the fixture.

My IT skills are ok but I would definitely say I am not 'highly skilled' and know nothing about coding so any response would need to "lead me by the hand"!

Thanks to anyone who can help!

[#2]

@Tony_Page2711 

You can use =HYPERLINK for this, but you can only include 10 mail recipients in one go. see attached.

[#3]

@Tony_Page2711 In the attached workbook, I use a range of data (rather an Excel table), and describe how the formulas work, including links to documentation.  Begin from the _Info worksheet.

[#4]

@SnowMan55 Wow! Thank you so much for your very detailed response. I will gradually work my way through it but, with my limited skills, it may take me a little while! At first 'skim-read' I am fairly sure it will provide me with all the solutions I require.

I'll let you know.....and thanks again!

Tony

[#5]

I know it has been a while.....but thanks to your response, I have managed to set up a practice database to generate emails to the desired recipients, so thank you. However.... in your example you have a worksheet entitled "Alternatives" and the part that converts the string of email addresses to a vertical list of email addresses doesn't seem to work in my database, even though I have copied the formula containing all of the IF, RIGHT, SUBSTITUTE, CONCAT, LEN, LEFT, functions (most of which are unfamiliar to me!) letter-for-letter into my worksheet (but adjusting the cell references accordingly). My version of Excel is from Microsoft 365 (Office) so it should support all of the functions you have included in your example. Any suggestions please? I could send a copy of my simple database that I did my 'learning' on (ie not the one I will ultimately use) if you want me to but it would contain actual email addresses so could, I guess, contravene Data Protection regulations?
Thanks
Tony