Hi,
Can someone please help me create a workflow to send out emails to the email address listed on the column "I" of the attached sheet. I would like to send one email only to the recipient even though the email address is listed multiple times. Also in the body of the email the information I want is what is listed in both the rows column "A" through "E".
For example:
one email sent to email address "Upali.dey@hallmark.com"
With the below information
| Vendor | Document Header Text | Document Number | Document Date | Amount in doc. curr. |
| 775234 | EPAY | 9800043996 | 6/6/2022 | -1500 |
| 711986 | EPAY | 9800051032 | 9/7/2022 | -314.43 |