FineReport自带的按钮发送邮件的事件,
没办法添加附件,
分享一段FineReport使用js代码发送邮件并添加附件的js
其中 A, B, C, D 四列对应的是邮件标题,邮件内容,收件人,抄送人
//js发送邮件代码
var mail_title = _g().getCellValue("A2")
var mail_txt = _g().getCellValue("B2")
var mailto = _g().getCellValue("C2")
var mailcc = _g().getCellValue("D2")
FR.ajax({
url:"${servletURL}",
data:{
op: "fr_email",
cmd: "deal_email",
FROM: "系统设定的发件邮箱",
TO: mailto,
SUBJECT: mail_title,
CC: mailcc,
MESSAGE: mail_txt,
FORMAT: "excel",
extype:"simple",
ISSHOWTPL: false,
sessionID:ssid
},
type: "post",
success: function(data, textStatus) {
var res = JSON.parse(data)
if(res.status=="success"){
FR.Msg.toast("邮件发送成功!")
}else if(res.status=="error"){
FR.Msg.toast("邮件发送失败!")
}
}
});
注意需要获取sessionID否则无法发送邮件
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAh4AAACOCAYAAAB+OgEgAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAABjqSURBVHhe7d0LeBTlvcfx3xLEkAuXQBNMBJWLF2xAKwpo4YANFQqiVlvEgigWS1EEixfA6rG2R9SjoqIUTz3HS3sQUTleWntsrRdaLVcPVy1iRQVqgpJQchMl2TPv7IyZTHY390k2+X6e59193//77mbz7Mw7/52ZnQ2VlpaHBQAAEIAOzj0AAECzI/EAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBIfEAAACBCZWWloedelSFhUUqLy93WgAAAPGZxOLonOxIw6fWxGPv3n9owIC+TgsAALRFO3d+YCcMTSFklZwYiQeHWgAAQGBIPAAAQGBIPBopFDI7lOquvuMBAGhL2l3iMTV9qlOrP5M0uCWa2voBAGjvGp94zK7a2NplthNvIuE/zdWInBQlZw9U3vhFTrTh8sbnObWGCYerTr1xEwxvouHv95d4cQAA2rrGJx5LwtbGtsiuFlgb3fASu9pkLsm7XzPWF6lsx7Oa8PabTrThpq2Y5tTq4Pr4CYGbZHiTDS8T95d4cQAA2romOtTSzb7NtG+b1gdW2bE/SR3ST9Lcvx4dCTZIiQry87XlxaVOO75Dn7yiqXc7DY/G7J1wH8seDgBAoli4YL527Pib06piYqavvprtHI/VN12oU7K7Kik5S6dMWm7H3MMKpVb9oFN3RRtv/H7JeN0/qIe+vWCVCo5d5kQtnz6mGcNzlJKco+E/We8Ep+i8cSM1KDtJ2jBNOelTnLhl01EaNXmiBk+8yglIhedP1JjcZBUuGqr0nrmavvLLSMemkJKzx+g3VtV9zS7v3gk37u2PxYxxH2vu6/IYAABa2pQpl+q+xfdaicYOJ2KSjh12bOrUehxFcDRb4lGYNUbP7PxU+zYv0eaVP7BjlZ/9Qrpsv1Ktepc9F+j2PRV23Ig23si4+rfa//YDOv6pC5V90XtOVHriuMu1Z+F6FZVs0fCPnnaic7Xw1pu19ZNK/VW/0m9f8+yyGFysd19b5zQi0hbM0ivbDum5CS9r/8aJenTSrEjHKTUPi0TjHQMAQFs08OSBmn3NHCvRuEc733vPLqZuYicNPMkZVXdNduVS7yd6o3TFbJ174/Paf/QAbXnr1a/6Xs7M0Jqt63VgzH4t3nKGHTNijT/zdemtUValcqVCSTdb8UjGlWn9vXetMT3sVnXmtRy2+pKctpf/dVa1i6x6f6u+P9JhiTbWZeKxnitWPF4dAICWVNuVS7dt26qHHoycyHnV1bP19a/n2vVozNYy8CuXnj35QV2+7UOtWfWAOlrttWs32PFz1p6gW/scr/zXq5IOI9b4iWNv0tqiwyr/aLfVGmnHDPPlmWvWFepwxUFteeD+SNBWZt+W2Ld+5iCPVGjfVnn2ky9UummeVas6DGMcaZU15ZUqWV/1/NESBZNAxBIvuTDxeI8FAKC1MInG3Gvn2SVe0lGbJko8Iht0r1unnKQ5PXN0wcpMrTg9VXkznfMwjntFM0MPaXlGpOmKNX5c382af1YvdRnypK586WE7Zty8bqH2XdxHqb3P1iO5cyLBInM+hjmQI3WzNuih5+xqxCbTl2ZXe5i+TXbVdtpdg9TjO9s0743bnEjEivF9NKr7sfreW5c7kZr8iYO37SYd5t4tbtwtJB8AgERxwgkn2KUxGnWo5cL0sXr04PP6/I1pyhrd09qIPuj0JIpia6PfRXsqw8qpw7bfmyhE24sRK+5VlzEAAAQtIX4kbtZ3d6t3x64afJ1058ZESzqkfCvpMI7u8JR9Xxv2TgAA0Dj8LD4AAOBn8QEAQNtD4gEAAAJTp0MtAAAA9RHrUEutiQcAAEBT4VALAAAIDIkHAAAIDIkHAAAIDIkHAAAIDIkHAAAIDIkHAAAITKMSj9TUzk4NAOKr73zhH898A7QNcRMPs6L7SzzRxvtLIrsia7pTA1AfZt0vLS13WlWizQn+WKLPGwCqi5t4mInCW+rCP97f9grP8yUm85r2Wmbh169XXv8MZfQ7VRO+e5cTbbjRY0c7NQB15SYO1dZ1p7hxL/9cEW3uAJC46nXlUjNBeCeBxraNcPiA0tKO0q6SMmU28U/OX2b9vTHvF2ly+odamrtQV+9a5fQ0v/DCzgrdXv1/Bdq7aHOAl+mPxjzG3xfveQC0XvU61FIX/vH+tl8o1M2+b+qkw9hllZ2FHdUh7URd9UZOJNgA4XCJCgryte2lh51IfIfy/6Qf3u80gHbMu/67c4A/5hbDJBPehMJtm35vn3cMgMRS68ml7sruXenj8Y/1t+viL7derGH9spSe0UfDLn3KjrmTU1k4rGLPRGVEG288d884LT0jR+fe8rz29X7AiVqJxGdP6KrRfdUzo69Gz98QiYUv1/fP+5ZO75eq8NtXqH/W5XbctvU4jbvsIg393lwnIBVNukjnnt5NRf8+Qlm9T9OPnv3Sjoe3dFZGvwlaYdXd1wy0V/HmAn/cZdYZt+2uP6bNugS0DaH8/IJqh1rS07s4teoTQDT+/vq2Xf74i0t/pYHTpqn7P15Q71Om2n3hwjuUNv9Klf5HhsL/mKS7tVzXZyfFHO86tPnXWjD5Sv3q1C0q/u8Bduy/Mztr5WMfaOW3O+lfL71Hdyy/3Uo8NmrDhgMaNWqCXv3zASWrSIO/0cseH7aSnVAoVO11frH+D+o+6jz9cl2+Lu5yr7qf+KnVt9TuM2L9r8XFB50akLi884ThX65jzSOmbnjXDX+/vx7r3ov1Ckgccc/xMCu4n3eF908A0cb7+ScMw/88Zc9cq4t++qL25wzQtjWvf9X3Sp9srVv/F/1zwn7duf50O2bEGn/26rBeHRlSuPIZpaX/zIpvteN9rL+3qaRMGVEO75jXctDqS4rR5/9/TTscLlJa2tet+l6np+ZYoD1y1wNzb0Rbf/x1I9r6430ufx+AxNGi32qJZdy0ZZqyYYdeX36POlrt9es32vFvrR6gfzsxVwV/GGK3XbHGf+f8W7W+6LA+320SghF2zJhlles2FulwxUFtW/pgJGgJh8vs+1L7trpwOBItClfP057LP6SyrfOt2o8iAceRVllXXqGSjVXPD7Q3/nnAMImDP3nw9/nrANqOWs/xaG7uBt3rpotP1A29+2rSqkw9flqqJlwTSSR0zEv6Yeg+PRo5H/Urscafc9xW3ZJ3rHqd9ZSm/88SO2bcuPoGfXrp8fra8WP12NevsmPhos5KS+th149KS1Hqi1UJhjlvIy2tp10/2vRtqer7xuIz1PuC7Zrz8s1OJOLxsb01NucE/WDNpU4EaJ/cBMIt3iTE8CYXbtw/xjBt9/EAEleLfZ32kqxz9XD+0yr/8wwdN66HFb/PjieKcLjYSkYytbOkTNnN8I0coC0zc4HLO0e43P5o84d/XgGQWGrd42FWcrfEW9mj9btt9/FeM87dq+O79NLQBdLP31zsRBPHPivpMAakPWPfA4jOXf+9xcwNbvHy95u6G3fHeuMAEk+99ngAAAA0Rouf4wEAANoPEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8gltJSVWzbrMqCAicQmxljxprHNIUXXnjBLs2l1HqdkydfrMcff9yJAGgWzCM1kHigTfnxj2fapSlU7HpfZQuvU+mcH6ly19+daE2mz4wxY81jGmvjxg26777FdjH15rBr1y7t3btX69atdSIAXMwjddPQeYTEA23K9u3b7dIUQl/rJaWkSmWlKl0wL+qkYU8WVp8ZY8baj2mE3bt365ZbbtHhw4ftYuomBiA4zCPNi8QDiKFDVpZSF90Tc9LwTxZmrHlMQ5WUlGjBgvkqLi52IrLrJmb6ACQe5pGaSDyAODoc1y/qpBF1srDGNlRFRYX9qeTjjz92IlVMzPSZMQASD/NIdSQeQC38k0bZ/Gvt0lSThfHII49ow4b1Tqsm02fGAEhMzCNV+JE4JCxz8lddj8OefPLJ+uUvlzmthjGfTsxEES6P/EpqqHNnpdyxuNGTRTQjR46w71ev/rN939S2bdumWbN+rNzcXD300FInCrQ/zCMN19B5hD0eAAAgMOzxQJvSXBm+91is+YRi2J9YmmgXqV9z/B+zZ1+tzZs3O63oFi1apLPO+qbTAton5pHYmmIeYY8HUAv/CWBmt6gp7rFa90Sx1u62236urDhny0+deilJB9BMmEeqkHgAcfgnC/dTiSneE8USYdLo3r279UnkDnV2Pml5jRw5UjNmzHBaAJoS80h1JB5ADObyxdEmC1fUSaMOl0VuSf3799dPf3qzQqGQE5EGDBhgxwA0PeaRmkg80KaYs85NaQrhT/NjThYu/6RhP6aVGzFixFefSjIyMuxPL8nJyXYbAPNIXTRmHuHkUiAG86njy1df1hHDzoo6WXiZ3aNfrnlTR5x9TqOuOui68cYbrNuQ7rzzzkigGdx7770aO3asBg4c6EQANDXmkZpIPAAAQGA41AIAAAJD4gEAAAJD4gEAAAJD4gEAAAJD4gEAAAJD4gEAAAJT7eu0ZWVlqqg47LQAICIpqaNSUlKcVnzMIwCiceeRaolHcfFBZWVlOi0AiCgo2Kf09C5OKz7mEQDRuPMIh1oAAEBgSDwAAEBgSDwAxPTqH1c5NaB+WHbg8i8LJB6tkPenhgG0LvVdP/3jWb/bNt7v2pF4tACzIPpLPNHG+0sim5o+1akBrZtZ18Lhmr+rGW0d9McSfT1F/Zj3233P3bo31p6ReLQAM3F5S134x/vb1cyuvpCHZjvxJhL+01yNyElRcvZA5Y1f5EQbLm98nlMDWi93g1Ft3XKKG/fyr5tR11W0KWYZcN9n7/zs1r2x9ozEoy1aYhbuIrtaYBb0JXa1yVySd79mrC9S2Y5nNeHtN51ow01bMc2p1cH1fFpAy/BvOLxtb9yIlpS4dcPfj7bH+/7yfldH4tECvAthXRdE/3h/u6Zu9m1zXE3hA6vs2J+kDuknae5fj44EG6REBfn52vLiUqcd36FPXtHUu50GECDv+uauc/6YWwx/IuK2Tb+3zzsGic19773c99r7noPEo8XUd4H0j/W362L1TRfqlOyuSkrO0imTltsxd7IsteoHnbor2njj90vG6/5BPfTtBatUcOwyJ2r59DHNGJ6jlOQcDf/Jeic4ReeNG6lB2UnShmnKSZ/ixC2bjtKoyRM1eOJVTkAqPH+ixuQmq3DRUKX3zNX0lV9GOjaFlJw9Rr+xqu5rBoISb93zx11mGXXb7vJq2iy7bZP3vXe5c5VbEEHi0Y4UZo3RMzs/1b7NS7R55Q/sWOVnv5Au269Uq95lzwW6fU+FHTeijTcyrv6t9r/9gI5/6kJlX/SeE5WeOO5y7Vm4XkUlWzT8o6ed6FwtvPVmbf2kUn/Vr/Tb1zy7LAYX693X1jmNiLQFs/TKtkN6bsLL2r9xoh6dNCvScUrNiR8IktlwuMuduyHxLpPeDYu3z/D3o30w77u3IILEo4W4E5dbauMf62/XxZjM7bpyYH+dPf1hJ2I9T4+b9L+/66+fFfxd146brwU5VYtEtPHGma9LR546TQ++/5Qqnz3XiUrXlUq/OTdbR3bsoXufvcuJDtHQoWPs2hlDOunUIb3sui3KS+80dKx9Pz23mzodc51V41oAaHlmPXOTB7fubkjcddDtd+uGO9Zw79F+uMuLWxBB4tECzATkLXXhH+9v18XZkx/U5ds+1JpVD6ij1V67doMdP2ftCbq1z/HKf/0Mu+2KNX7i2Ju0tuiwyj/abbVG2jHDfHnmmnWFOlxxUFseuD8StJXZtyX2rZ85yCMV2rdVnv3kC5VummfVqg7DGEdaZU15pUrWe58faF7+9c5wNybeddDf56+jfXGXF7cggsSjzYps0L1unXKS5vTM0QUrM7Xi9FTlzXTOwzjuFc0MPaTlGZGmK9b4cX03a/5ZvdRlyJO68qWqvSE3r1uofRf3UWrvs/VI7pxIsMhMuuZAjtTNTMDP2dWITaYvza72MH2b7KrttLsGqcd3tmneG7c5kYgV4/toVPdj9b23LnciQDDcBMIt/o2JN7lw49E2OKbtPh5tm3d58S4f7R2/TtsK+CehxrQvTB+rRw8+r8/fmKas0T2t+IN2PHEUW/9PF+2pDCuH9bTFmUsdnz3mu/w6bQxm3XN510mX2x9tffWvx22Nu+y0J973NNr729bf81j88wh7PFqIWQDdEm9BjNbvXbBN8Zr13d3q3bGrBl8n3bkx0ZIOKd9KOoyjOzxl3wOthbu+eYtZF93i5e83dTfujvXG0bZ4329vcWPtHYlHC3EnJHcS8vLGovW7oj3Htx7frn9WfK5PNqzQDd9wggmk11f/0yQnArQO3vXNLbH4+926/zHxngOJx/s+xyvtHYdaANSKQy0AGsudR2okHikpnZ0WAESUlZXXK/FgHgHg584jNRKPiorDTgsAIpKSOtYr8WAeAeDnziM1Eo8DByI/LgYArm7dutcr8WAeAeDnziM1Eo+6Ti4A2o/6zA1m7Ic1LyODdiiltED9+g3QyJEjnEh0q1f/2anVXWFhkcrLy50WWrPOnTurqOgzZWZmkXgAqBsSDzSEm3gYbvLhTzJMvCGJx969/9CAAX2dFlqznTs/0Oefl36VePB1WgAAEBgSDwBA4Px7QKIdjqntEA0SE4kHgFbnZ4Oq/zig64P/WqplV5/utNBWxDrcYmKJlHxMTZ/q1BAPiQeAVmfI6KpfPa5utx77/cdOHYnIJBKxkglvXyIlHK688XlOrYEWV7/Eemhx1WXXk3uerO/c8KzawvfFSDwAtDrj749+yfy+0xc5NSQqsxcj1smk3sMusca0ZtNWTHNqDXStuaT6Abu631xe/VopXPmZ3c7/5FXdErpEfX7+pd1OZCQeAFqNcLhE+z8t0PuvPOpEgLqptqfAU4JRooL8fG15canTboyu9m2GfWsJ9bDvuh2RpWF3PqqSW/7VbicyEg8AzWbHvdM06fTeGj3sXzR3ys+caOy43h2kWXMu1ZQfzXcCEeHt/66ZI/vogmlvOBEkuqbeoxHtx9hMMd7+6fk6KfNIpWfnaty3rrNjtg+X6XuDMpU2YKzu2O7ELLHGx3yeTUdp1OSJGjzRd27Sx0s1MTdDyceM1aJdkdD5549X3sBkhf80UwNTUnTMhFWRjjo5zyqPRaoJjOt4AKhVQ6/jMaNfls59c7cm9KxU8d4d6nrM4LjxcGVYoQ4hDbP61/y9wI4Zj1vtD174u+Ynv6TR355drQ+tV12u42G4h1a894Y35ue/jkesvRsm+TjT6rtizyFN71Wpwg+3q0e/0+y+ZUeE9OXOcs1M+R91yvrCGhs5VBJrfKy4zFbU+vPmNbjJjvFockir15bqoQ7XKHXIcIUPXaG1a1/XsGGjteq13Ro3dJc6p+RZjznkPCLC/zxV7X9a9TOs+o5IR4LwX8eDxANArRqaeBze+rSeWP5HvVeUoVOm/1wXn3FE3LjLn3jkWe1V7+erizUB+/vQesW7cqk3mYiVXBh1TTziObzh11r08O+06bOeGvmTxZozIrK89bSWp/12zehjbdA/smuxxseKu/wJQ6bV/pvVzlCh1Xei1bfPjnvH+R9jxE48/tOql1n12ZGOBEHiAaDeGpp4PP9/BTon92vqWPy0vjnkCSth+F3cuBEOl2p4/7562Uo0uloTrnGflWx0evVjXXnES/rmiJm695ndOvPUTnYfWi/vHo/aREsw4iUk9Uk8Hlmbr0tOy9IRB3+tTj2WWcvYW3b8Lmv5Sn2nSDNOTNGBdX9U5tDxdjzW+FjxiFIrKUizTwp1z894KCmk97aX687Q9eo88HiFK6yEIVysUIcuOmCN6+o8Zl9FWF/76sSHg1asa9XzhK2kpUMPFZXv1YYbj9FF/b7QgWuCOnelaXDlUgCB2fJv8zRn9LH65pm3K3fKbU40djz8TpaddBjn9O+lYe9EPhdd88hleuvCE3TFyrPUsc8QrVzGNdnbmmgJRqyko77evHaGxvZLVafsBRp+9WInKt2w5Rd6+YJjlNpzsK5991+caOzxseLaZE5kTbOrPaxkJrTJruqqd+7Wzgt6qdf5u3T3O5G9FCbpMLqlWzfpkcdkWgmKzf46beTkUvt5zNdpraTDyO4zVvclP6WPEyzpiIY9HgBq1dA9Hmjf6rPHo774rZbEwR4PAADQYkg8AACtzvLly+1zPNzy5JNPOj1IdCQeAIBWZ9KkSRoyJPK7POb++9//vl1H4iPxAAC0OklJSbrttts0atQo+9600TZwcimAWnFyKRqiuU8uReLgOh4A6qW+ice+fVzgC0B1JB4A6qy+iQfzCAA/d27gHA8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAYEg8AABAQ6f8BhZJfIMqyesIAAAAASUVORK5CYII=)
|