{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 兄弟一词,经得起流年. 的问题《Shell Script : Send html formatted email while ins》','https://www.manongdao.com/q-1033586.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I am trying to send html formatted email via shell script while reading a tab separated text file in array and need some help. I can see there were multiple similar question on forum and I also have multiple working scripts which can send html emails but I am not able to fit that code when I am inside an array.
apart form this I also need to use a variable and later use it but cant fit it inside my code, for example i have below code to extract first name and make the first letter uppercase but not sure how to merge it in my existing code.
SplitName=$(echo firstname.lastname@domainname.com| cut -d'.' -f 1)
Firstname=`echo -e $SplitName | sed -r 's/\<./\U&/g'`
below is my main code and data file and is working fine and creates a html formatted email but the problem is when it reads "print substr(a[user], 2) | cmd" it looses all formatting so the email I receive do have html formatting at start but not when it show me the records I need.
Any help will be appreciated .
Here is my data file
10011,5-Jan,Sam,Sam@companydomain.com
10023,8-Jan,Mutthu,Mutthu@companydomain.com
10010,8-Jan,Mutthu,Mutthu@companydomain.com
10026,15-Jan,Sam,Sam@companydomain.com
10050,10-Jan,Jordan,Jordan@companydomain.com
10021,12-Jan,Andrew,Andrew@companydomain.com
Here is my code
awk -F '\t' '{ a[$4] = a[$4] ORS $0 }
END {
for (user in a) {
cmd = "/usr/sbin/sendmail -v " $4
print "From: static.name@domain.com" | cmd
print "To: " $4 | cmd
print "Cc: static.name@domain.com" | cmd
print "Subject: Some text here " $2 " Some more text"| cmd
print "MIME-Version: 1.0" | cmd
print "Content-Type: text/html" | cmd
print "Content-Disposition: inline" | cmd
print "<font face=Calibri><font size=2>Some text here<br><br>"| cmd
print substr(a[user], 2) | cmd
close(cmd) } }' myfile | grep Sent >>"$HOME/maillog.txt"
Below code is to generate html table
<html>
<head>
<style>
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
</style>
</head>
<body>
<table style="width:100%">
<tr>
<th>Number</th>
<th>Date</th>
<th>Name</th>
</tr>
<tr>
<td>10011</td>
<td>5-Jan</td>
<td>Mutthu</td>
</tr>
</table>
</body>
</html>
please refer below link for more details. Shell script -How to group test file records based on column value and send email to corresponding receipents.?
You need an empty line between the email headers and the body; and you need to add HTML formatting to the table in order for it to render correctly. Something like this, perhaps:
I kept this simple to highlight the general structure. You can add more embellished HTML formatting to your heart's content once you understand how this works.