Im trying for a project to send a email with a bit of text and a attachment but dont find how to do it tried some things also lloked on the internet but dont realy find something similar because the person who will get the email is something we get out a excel file that will be the client base.
So the 2 project that are in here are one that can send the mail with attachment but without text and the mail with text and attachment is the attachment not being able to open. I tried changing to what every thing is send but that doesnt work or im not doing it right im a bit new to all this
Thanks in advance and sorry for the bad english
so here is the code to the first one that send the attachment corectly.
[{"id":"40815c0a.7e59c4","type":"tab","label":"Flow 4","disabled":false,"info":""},{"id":"c9c68386.8e578","type":"inject","z":"40815c0a.7e59c4","name":"","repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":240,"y":180,"wires":[["1741bf96.e3c538","c81db63b.f5b708"]]},{"id":"1741bf96.e3c538","type":"file in","z":"40815c0a.7e59c4","name":"","filename":"D:\\Games\\Map1.xlsx","format":"","chunk":false,"sendError":false,"x":460,"y":200,"wires":[["56caa4ea.f0e6f4"]]},{"id":"c81db63b.f5b708","type":"change","z":"40815c0a.7e59c4","name":"","rules":[{"t":"set","p":"attachments","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":520,"y":400,"wires":[["60dc3d9d.3373e4"]]},{"id":"60dc3d9d.3373e4","type":"debug","z":"40815c0a.7e59c4","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":1010,"y":540,"wires":[]},{"id":"56caa4ea.f0e6f4","type":"book","z":"40815c0a.7e59c4","name":"Map1","raw":false,"x":750,"y":120,"wires":[["4ab5d25b.c9ad24"]]},{"id":"4ab5d25b.c9ad24","type":"sheet","z":"40815c0a.7e59c4","name":"","sheetName":"Blad1","x":880,"y":100,"wires":[["729a6c8.5c1e794","8e740f02.529a8"]]},{"id":"729a6c8.5c1e794","type":"cell","z":"40815c0a.7e59c4","name":"","address":"A1","dataType":"w","x":1030,"y":100,"wires":[["da3e907a.c9219"]]},{"id":"8e740f02.529a8","type":"cell","z":"40815c0a.7e59c4","name":"","address":"F1","dataType":"w","x":900,"y":160,"wires":[[]]},{"id":"da3e907a.c9219","type":"change","z":"40815c0a.7e59c4","name":"","rules":[{"t":"set","p":"to","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1130,"y":240,"wires":[["f0fad678.519c98"]]},{"id":"75c13d78.8bc3fc","type":"e-mail","z":"40815c0a.7e59c4","server":"smtp.gmail.com","port":"465","secure":true,"tls":false,"name":"","dname":"","x":1230,"y":540,"wires":[]},{"id":"f0fad678.519c98","type":"function","z":"40815c0a.7e59c4","name":"","func":"\n\n\nmsg.payload = \"Email Body Message\";\n\nmsg.topic = \"Subject Message\";\n\n\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1120,"y":300,"wires":[["72dba50e.beb264","caad305.a2e985"]]},{"id":"72dba50e.beb264","type":"file in","z":"40815c0a.7e59c4","name":"Test","filename":"C:\\Users\\Gebruiker\\Downloads\\1.PDF","format":"","chunk":false,"sendError":false,"encoding":"none","x":1010,"y":360,"wires":[["75c13d78.8bc3fc","caad305.a2e985"]]},{"id":"caad305.a2e985","type":"debug","z":"40815c0a.7e59c4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":1230,"y":480,"wires":[]},{"id":"5afe5248.eb8a4c","type":"comment","z":"40815c0a.7e59c4","name":"Deze stuurt het bestandje wel goed door maar zonder tekst","info":"","x":700,"y":60,"wires":[]}]
and this is the one with broke attachment but with text
[{"id":"a248e3f6.04a6c","type":"tab","label":"Flow 5","disabled":false,"info":""},{"id":"73b0b8ce.1d7f3","type":"file in","z":"a248e3f6.04a6c","name":"","filename":"C:\\Users\\Gebruiker\\Pictures\\2.jpg","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":460,"y":440,"wires":[["cda30ce2.0fc9a"]]},{"id":"cda30ce2.0fc9a","type":"function","z":"a248e3f6.04a6c","name":"Prepare Email","func":"msg.attachments = [{filename: \"2.jpg\", content: msg.payload[0]}];\n\n\nmsg.payload = \"Email Body Message\";\n\nmsg.topic = \"Subject Message\";\n\n\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":860,"y":380,"wires":[["77339089.8bb548"]]},{"id":"9c789286.63f0d","type":"inject","z":"a248e3f6.04a6c","name":"","repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":100,"y":220,"wires":[["f01cf936.a41da"]]},{"id":"f01cf936.a41da","type":"file in","z":"a248e3f6.04a6c","name":"","filename":"D:\\Games\\Map1.xlsx","format":"","chunk":false,"sendError":false,"x":320,"y":240,"wires":[["f24e6c8.d84bd9"]]},{"id":"f24e6c8.d84bd9","type":"book","z":"a248e3f6.04a6c","name":"Map1","raw":false,"x":610,"y":160,"wires":[["aaae0997.fc1a08"]]},{"id":"aaae0997.fc1a08","type":"sheet","z":"a248e3f6.04a6c","name":"","sheetName":"Blad1","x":740,"y":140,"wires":[["f9cfa2d5.6b3fd8","751acde8.2dea74"]]},{"id":"f9cfa2d5.6b3fd8","type":"cell","z":"a248e3f6.04a6c","name":"","address":"A1","dataType":"w","x":890,"y":140,"wires":[["5aafded.8d5702"]]},{"id":"751acde8.2dea74","type":"cell","z":"a248e3f6.04a6c","name":"","address":"F1","dataType":"w","x":760,"y":200,"wires":[[]]},{"id":"5aafded.8d5702","type":"change","z":"a248e3f6.04a6c","name":"","rules":[{"t":"set","p":"to","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":770,"y":280,"wires":[["cda30ce2.0fc9a"]]},{"id":"77339089.8bb548","type":"e-mail","z":"a248e3f6.04a6c","server":"smtp.gmail.com","port":"465","secure":true,"tls":false,"name":"","dname":"","x":1110,"y":380,"wires":[]},{"id":"6d541020.7117","type":"comment","z":"a248e3f6.04a6c","name":"Uitleg denk wijze","info":"Bij deze heb ik geprobeeerd via de functie blok het bestand te versturen zodat de tekst er ook in staat maar dit zorgt ervoor dat het bestand niet bekijkbaar is .","x":480,"y":60,"wires":[]}]
this is the one with the bad attachment
