Email subject based in a Data Table

Help
,
1

Hi,

I’m trying to send a loop of emails based in a data table, the subject for each email is in a determined column, how can I set this for each email?

Also I’m trying to attach a different pdf file based in each row, these files will be stored in the same place.

Data table basically will look like this, please help.

Document Subject Email File
A A - 01 abc A.PDF
B B - 05 sdf B.PDF
C C - 25 asdf C.PDF

2

Hi @flemusc101

Use Build Datatable Activity
Get outlook mail message
Mail message set variable as System.net.mail.message
For each item in MailMessage
Document Subject Email File
add data row
intcount.tostring,item.subject,item.attachment

Thanks
Ashwin S

1 Like
3

Hi @flemusc101

Do the following steps:

  1. Create a data-table as per your requirement
  2. Read all the emails that you require
  3. Do a for each loop and find the emails having PDF’s
  4. If this is true, add them to add data-row and store the required info as per the earlier build table
  5. If required you can later save it in an excel file for conveyance :slight_smile:

Hope this helps, Good day :smiley:

1 Like
4

Hi Shubham,

What I’m trying to do is the opposite, im trying to send bulk emails to different addresses, and each email has to contain a file, this file is unique based on the data table, also the subject that these email must contains is unique too.

Thank you!

5

It can be done in the same way, just read the content from the data-table now :smiley:

And the subject will be read row by row on the basis of the column of the datatable :slight_smile: