Hi @cardiofaz ,
it's quite simple and the Emailer is the right choice. If your Excel sheet has 'user', 'password' and 'email' columns, when you read the sheet with the Excel Reader you get 1000 features with these attributes. Send them to the Emailer, use the 'email' attribute in the 'To:' parameter, setup other values with your email credential (smtp or Gmail account) and write a body cointaining some fixed text and these attributes:
Hi @Value(user),
this is your @Value(password).
Hope that helps!
Just a couple of thoughts
- Sending passwords by mail is very insecure, especially if the user isn't forced to immediatly change the password. If possible, you should consider only sending them the link to reset the password, where they get a one-time link back to their registered email.
- Be careful about sending large amounts of mail very quickly, unless the mail server "knows" you and your use case, you or your organisation might end up on a blacklist for spammers, and it can be a hassle to fix later. If you plan to use FME and the Emailer transformer, consider also using Decelerator transformer to reduce the frequency. Perhaps also communicate with your ISP or IT department before doing this, as the mail allowances can vary a lot.