I’ve tried to solve my problem for hours, now I think I could need some help.
I’m trying to send an email to several users. Sending emails with a name parameter for instance is working (I’ve tried the example email_sendout before). But I’m having problem with sending each user only data based on rows from a CSV.
- Import delimited CSV and run some calculations
- Export into XLS
- Send email to a user with XLS attachment
- Import user list from delimited CSV
- Project 1 iteration
Purpose: If there is certain data missing in the output XLS in project 1, each user from project 2 should get only this certain dataset.
After running P2, each user from the list gets the same XLS containing all data (also the one for other users).
| Reference | user |
| 100 | 1 |
| 200 | 1 |
| 300 | 2 |
| 400 | 2 |
User 1 gets an XLS containing 100 & 200, user 2 gets 300 & 400.
How can I achieve a filtering of the data and, if applicable, generate a new dataset per user?
Alternatively, no XLS has to be generated or attached. One email per row can be sent, containing all info inside the email body.
Thanks in advance,