Use csv file to send emails

[rui_silva1]

Hey

I need a feature in backoffice, something that the admin can upload a csv which is going to contain information about the costumer and the shipping like the tracking number.

It's needed to upload the csv file and  send an email to all costumer in the file telling them that their order as been shipped and the tracking number associated.

But I don't know the best way to do this. Any help?

Thanks

[Sanjay Jethva]

Hey @rui_silva1 

Please refer:

https://magento.stackexchange.com/a/173838/24801

You can set logic in uploadAndImport method to send mail

You can refer to https://magento.stackexchange.com/a/132403/24801 for sending the mail.

I hope it helps.

[rui_silva1]

Thanks for the reply @Sanjay Jethva 

I didn't understand quite well, I made a custom page at magento backoffice, I have a form with the file uploader and in the action Tracking/Upload/Post then I have app/code/Custom/Tracking/Controller/Adminhtml/Upload/Post.php but it doesn't seem to go to the controller. After this what should I do, use that system config? I want something as simple as possible I'm not experienced with magento sorry I'm getting some issues

Thanks!