带有表格的html电子邮件从plsql包发送并在莲花笔记中查看 [英] html email with tables send from plsql package and viewed in lotus notes
问题描述
我正在尝试从oracle plsql包发送html代码，并且我收到了lotus notes客户端中的电子邮件。
但是，当Lotus Notes中的窗口大小发生变化时，html表格会缩小。
请帮助我在html代码中放置什么以避免此操作..
在表格样式中，我包含了表格布局：固定，cellpadding和cellspacing归零，还包括最大宽度和最小宽度以及最大高度和最小高度，以锁定表格不被缩小。这里是我的代码：
< html>
< head>
< style>
table.table1 {
Cellspacing：0;
Cellpadding：0;
最大宽度：500pt;
最小宽度：500pt;
border：1px纯黑色;
Border-collapse：collapse;
table-layout：fixed;
}
Tr，td {
Border-collapse：collapse;
}
< / style>
< / head>
< body>
< table class =table1>
< tr> < TD> Sl.no< / TD> < TD>日期和LT; / TD> < td>项目名称< / td> < td>项目数量< / td> < td>交货日期< / td> < / TR>
< tr> < TD→1< / TD> < td> 2016年11月17日< / td> < TD>电池和LT; / TD> < TD> 11< / TD> < td> 2016年12月20日< / td> < / TR>
< / body>
< / html>
但是，所有这些在莲花笔记8.5中都失败了。
< tr>< td colspan =5>< img width =500height =1src =../../ DelOptionSpacer .gif注意/>< / TD>< / TR>
其中源代码导致数据库的DelOptionSpacer.gif图像资源（这是9.0中的一个清晰的gif邮件模板...不确定8.5）。您可能更好使用 =../../ DelOptionSpacer.gif？OpenImageResource
其他提示：
- 您在
< / table>
- 您可能希望考虑使用
< th>标签，而不是< td> - 您可能希望考虑使用
我知道Domino有时会令人沮丧！我经常告诉人们这就像使用Duplo模块一样 - 你可以非常快地接近你想要的东西，但是通常很难得到你想要的东西。
1 - 希望我错了吗？任何人
2 - 未经测试
I was trying to send html from oracle plsql package..the code worked and i received the email in lotus notes client. But the html table gets shrunk when window size is changed in lotus notes.
Please help me what should i put in html code to avoid this.. In the table style, i had included table layout : fixed, cellpadding and cellspacing to zero also included max width and min width and max height and min height to lock the table from getting shrunk. Here is my code:
<html>
<head>
<style>
table.table1 {
Cellspacing: 0;
Cellpadding: 0;
max-width:500pt;
min-width:500pt;
border: 1px solid black;
Border-collapse: collapse;
table-layout: fixed;
}
Tr,td {
Border-collapse: collapse;
}
</style>
</head>
<body>
<table class="table1">
<tr> <td>Sl.no</td> <td>Date</td> <td>Item Name</td> <td>Number of items</td> <td>Delivery date</td> </tr>
<tr> <td>1</td> <td>17 Nov 2016</td> <td>Battery</td> <td>11</td> <td>20 Dec 2016</td> </tr>
</body>
</html>
But all of this fails in lotus notes 8.5.
Sadly, I have not figured out a reliable way to get the Lotus Notes client to do style tags.[1] You could try the style attributes within each cell, but your best bet is to avoid CSS wherever possible and, however painful it may be, force your table width with a row like2
<tr><td colspan="5"><img width="500" height="1" src="../../DelOptionSpacer.gif"/></td></tr>
Where the source leads to the database's DelOptionSpacer.gif image resource (which is a clear gif in the 9.0 mail template... not sure about 8.5). You might be better off with a src of ="../../DelOptionSpacer.gif?OpenImageResource"
Other tips:
- You are missing your
</table>tag at the end. - You might wish to consider using
<th>tags instead of<td>tags in the first row.
I know Domino can be frustrating sometimes! I often tell people it's like building with Duplo blocks - you can get close to what you want VERY quickly but, often, it's not easy to get exactly what you want.
1 - Hopefully I'm wrong??? Anyone???
2 - untested
这篇关于带有表格的html电子邮件从plsql包发送并在莲花笔记中查看的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
