AVipani
(AV)
August 11, 2020, 8:11am
1
Dear All
Am looking for guidance, on how to personalize the email body, for a range of sender address.
I have an excel sheet with a column for all the Email address, for which email needs to be sent.
In my project, i have for excel row loop, where i open Outlook account, and send email. The to field value is picked up from the Excel column.
In the body section - i would like to personalize the message, that would include something like this:
Dear
Please find the URL , that you had requested access for.
Signature to include company logo & RTF.
Can you please guide me on the above.
Thank you in advance.
1 Like
Is there any variability in personal email body sent for every person
AVipani
(AV)
August 11, 2020, 8:45am
3
Hello Nived,
Yes, i define which URL to embed, based on their medical profession
thanks & regards
1 Like
Is the url is Available in excel file @AVipani
AVipani
(AV)
August 11, 2020, 9:25am
5
Dear Nived
Yes, the URL is pasted in Excel as part of Data scraping activity.
Hi @AVipani
You can do like this
Consider url.is stored in URL coloumn of excel file
Under for each row,
Assign url to variable let’s say URL = row(“URL”).ToString
Use the mail activitiy and inside the body do like this
“Dear”+Environment.NewLine+“Please find the”+ URL+ “, that you had requested access for.”+ Environment.NewLine+“Signature to include company logo & RTF.”
THIS is the way u want to write mail if url varies for each person
HOPE IT HELPS,
MARKS IT AS SOLUTION IF IT WORKS
HAPPY AUTOMATION
NIVED N
AVipani
(AV)
August 11, 2020, 9:36am
7
Dear @NIVED_NAMBIAR
Thank you for the quick revert.
Can you please guide me on declaring a variable. Am a newbie and want to know where to do this.
Am using StudioX
thanks & regards
Hi @AVipani
Have a look to below workflow which will give you idea how can you Personalize Email Body :-
Challenge 11 _ Data Extraction Process Using Regex.zip (30.5 KB)
For Reference you can go through below Link created by @sharathraju489 :-
Mark as solution and like it if this helps you
Happy Automation
Best Regards
Er Pratik Wavhal
2 Likes
AVipani
(AV)
August 11, 2020, 11:07am
10
Dear Pratik
Thank you for sharing, however i issue i have is that, am using StudioX and all solutions are for Studio
thanks & regards
AVipani
(AV)
August 11, 2020, 12:17pm
11
The only thing i could manage to come close to was, i created a word template doc, and had the email body in it.
i used replace text activity and referenced the first name from Excel sheet column & the embedded URL from URL column.
Had them within the For each loop. Worked for the first record, however started throwing up RPC error. Need to troubleshoot that.
Quite a clumsy solution, for a very basic requirement
AVipani
(AV)
August 13, 2020, 11:00am
12
I managed to get this working in StudioX
I did the following, as suggested by @NIVED_NAMBIAR
In the Send mail activity, on the body section, added the Environment.NewLine for the required fields from Excel. The required column name is within the body section of the mail.
Thank you.
1 Like
system
(system)
Closed
August 16, 2020, 11:00am
13
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.