I am facing an issue regarding a workflow I am developing where I get some data from an Excel file to then use as variables in the body of the Outlook.
For each Read Cell activity, I have a variable that stores the values from the Excel file. One of the cells I have needs to be written in the body of the email. In that cell, I have text that is a personal email. I did a Write Line activity to debug and I can see that email written. I also made the email to be shown on a Notepad application. From this variable, I can pass the email into the Send To field from Outlook.
However, in the body of the Outlook message the special character “At” disappears. For example, an email such as firstname.lastname@example.org gets a “transformation” into the Outlook body as namemail. Meaning that, not only the special character “At” disappears but also, the letter next to it. Any advice for how to overcome this issue?
I provide in annex a workable workflow and an excel file.