User Profile
Tony_Page2711
Copper Contributor
Joined 12 months ago
User Widgets
Recent Discussions
Re: email some but not all from data in excel
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 Tony2.1KViews0likes0CommentsRe: email some but not all from data in excel
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! Tony2.6KViews0likes0Commentsemail 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 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.7KViews0likes4Comments
Groups
Recent Blog Articles
No content to show