Unable to send outlook mail for each worksheet individually

Troubleshooting
1

Hi everyone,

i want to send each worksheet for each person individually in excel through outlook mail . can anyone solve my issue. please suggest me the code
i want to send these details…

  1. sheet 1 = person 1
  2. sheet 2 = person 2
    3.sheet 3 = person 3

Thanks and Regards
Priyanka

2

One option - create mail template and declare variables then

Open Workbook
List Sheets
For Every sheet in workbook
      Fill mail template
      Send mail

Excel
Mail
You can see some similar examples on portal for example https://github.com/robocorp/example-pdf-invites-creator

2 Likes
3

Hi @linkraivo

Thanks for your suggestion, i will try