KenMSchwartz
asked on
looking for a way to send HTML formatted emails from a DTS package
I have DTS package that properly creates an output string that looks like:
<html>
<body>
<table>
<tr>
<th>Partner</th>
<th>PO_Number</th>
<th>PO_Control_Number</th>
<th>PO_Date</th>
<th>INV_Number</th>
<th>INV_Date</th>
<th>INV_Control_Number</th
</tr>
<tr><td>BERGENT</td><td>04
<tr><td>CARDT</td><td>Z484
<tr><td>D&KHEALTH</td><td>
<tr><td>D&KHEALTH</td><td>
<tr><td>HDSMITH</td><td>05
</table>
</body>
</html>
I am attempting to send an email using the DTS Send Mail Task, in which I want to display the information in table form. What I get is just the text noted above. What am I missing? This is the last piece of the puzzle and I'm going nuts.
Any help would be greatly appreciated. I know that for this is probably a cake walk for most of you, but since I have no hair left, I am going to assign a high point value just to get it over with.
Thanks in advance for you help.
KMS
<html>
<body>
<table>
<tr>
<th>Partner</th>
<th>PO_Number</th>
<th>PO_Control_Number</th>
<th>PO_Date</th>
<th>INV_Number</th>
<th>INV_Date</th>
<th>INV_Control_Number</th
</tr>
<tr><td>BERGENT</td><td>04
<tr><td>CARDT</td><td>Z484
<tr><td>D&KHEALTH</td><td>
<tr><td>D&KHEALTH</td><td>
<tr><td>HDSMITH</td><td>05
</table>
</body>
</html>
I am attempting to send an email using the DTS Send Mail Task, in which I want to display the information in table form. What I get is just the text noted above. What am I missing? This is the last piece of the puzzle and I'm going nuts.
Any help would be greatly appreciated. I know that for this is probably a cake walk for most of you, but since I have no hair left, I am going to assign a high point value just to get it over with.
Thanks in advance for you help.
KMS
For an email to be displayed like an HTML page, you have to set the content-type to "text/html". Unfortunately, in DTS Send Mail Task, there is no option for you to be able to change this property. An alternative is for you to create an html file and attach that in your email.
ASKER
rafrancisco,
Thanks for that suggestion. I thought about that as well, but the client would like to see it in the body of the email. Any other suggestions.
Thanks for that suggestion. I thought about that as well, but the client would like to see it in the body of the email. Any other suggestions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
graft,
Outstanding solution. Thanks
Outstanding solution. Thanks