Forum Discussion
email some but not all from data in excel
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 head...
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.
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
- 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
