Send maill

Help Studio
,
1

can anyone tell me, How copy that table from excel to mail body to send mail and all this columns have multiple values how can i do this

image
image1517×292 27.8 KB

2

Hi @yogitagaikwad2206

Can you share input Excel file

3

sorry, i can’t share, can u plz tell the solution

4

@yogitagaikwad2206

you cannot copy the table from excel to mail directly

instead read the data into datatable then if you dont need formatting can use create html content activity directly and use the output in mail activity

else if you need formatting then you have to go with looping and creating the table with each formatting you need

cheers

5

Hi @yogitagaikwad2206

Check the below and try.
Copy Excel Table To Email.zip (187.4 KB)

image
image746×3360 224 KB

Hope it helps!!

6

here the column name is same but value are dynamic sometimes it less or more
if rows are increases, this code will work?

7

@yogitagaikwad2206
No,It will work Because as the excel contains the data normally not in the tables.
If The data in excel is in tables. Then we can able to give the table name instead of Range.

Hope you understand

8

image
image926×290 16.1 KB

for this which page i have to indicate?

9

Open outlook and indicate on new email

10

image
image597×607 16.9 KB

here is sign in & create one option available then which option i have to select

11

@yogitagaikwad2206
Login with your Outlook account

12

actually i don’t have outlook i have gmail account