Forum Discussion
Max86
Jan 14, 2021Copper Contributor
Excel automation options - Personalized emails + Excel attachments
Dear Community, For my current assignment I have a task that I want to automate. I basically have one big table of data and I want to send personalized team e-mails with the specific data of that...
adversi
Jan 14, 2021Iron Contributor
Max86 Without access to VBA, the most you can get is using the CONCATENATE function to set up the text for the email. You can get pretty creative using this function, controlling sentence structures, creating NESTED IF statements to control the final output, and combing data from other cells to make it a more tailored message.