Forum Discussion
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 tema. This means that with one click I want to send an email to team Y with information about team Y and team Z with information about team Z. I have already tried some power automate options but with no success. Also, when it comes to vba coding the problem is that I need to convert the newly created file with the script to xlsx. again since my company does not allow xlsm. files. Didn't manage to do this conversion.
So my question to you is, what is the most efficient way to do personalized emails. I am open to all the options that seem fit but need guidance on how to create these personalized files. Thanks in advance for your response!
Kind regards,
Max
1 Reply
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.
