Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
| Search | Today's Posts | Mark Forums Read
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 27th, 2006, 03:48 AM
Registered User
 
Join Date: Nov 2006
Location: Bangalore, Karanataka, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to cvnitkumar Send a message via Yahoo to cvnitkumar
Default Sending Html Emails through DTS

I m sending E-Mails through DTS packges,but emails should be in HTML format , how can set HTML email body format in DTS SendEmail Task.



Vinit JC
Bangalore
  #2 (permalink)  
Old January 9th, 2007, 01:00 PM
Registered User
 
Join Date: Jan 2007
Location: Memphis, Teneessee, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Vinit,

You have to use the following object to achieve the same.

Set objMail = CreateObject("CDO.Message")
Set cdoConfiguration = CreateObject ("CDO.Configuration")

and mail body type should be HTML body as mentioned below.

objMail.HTMLBody=lStrProliteString

If you want any clarification please let me know.

Christopher Britto,
Teneessee,
US.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple emails with one DTS package ninel SQL Server DTS 1 October 23rd, 2006 08:00 AM
Sending automatic emails maitias C# 2005 3 March 3rd, 2006 09:51 PM
Sending emails from smartphone application. unprsandeep C# 0 March 24th, 2005 02:01 PM
Sending automatic emails in Access marcin2k Access VBA 10 March 6th, 2005 03:48 PM
sending emails from vb.Net elan22 General .NET 5 May 27th, 2004 08:53 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.