从程序中动态查询出数据,生成excel文件,再加入到附件中
public String sendAttendedFileMail() throws Exception {
MimeMessage mimeMessage = mailSender.createMimeMessage();
// multipart模式
String[] tos={"abc.cn","def.cn"}; //收件人
String[] ccs={"z.cn","x.cn","v.cn","b.cn"}; //抄送人
MimeMessageHelper mimeMessageHelper = new MimeMessageHelper(mimeMessage, true, "utf-8");
mimeMessageHelper.setTo(tos); //收件人
mimeMessageHelper.setCc(ccs); //抄送人
mimeMessageHelper.setFrom("hellomady@163.com");
mimeMessageHelper.setSubject("[Hello迈迪]-分销统计-迈格森渠道");
StringBuilder sb = new StringBuilder();
sb.append("<html><head></head>");
sb.append("<body><p>各位老师好:</p></body>");
sb.append("<body><p>本邮