Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
.NET Framework GroupsView
.NET Distributed_Apps
.NET
.NET ADO.NET
.NET ASP.NET
.NET ASP.NET Security
.NET ASP.NET Webcontrols
.NET ASP.NET Web Services
.NET Clr
.NET Compact Framework
.NET Drawing
.NET Interop
.NET Performance
.NET Web Services
.NET Windows Forms
.NET Windows Forms Controls
.NET General
.NET Csharp
.NET Visual Basic
.NET Vc
.NET Security
.NET Xml
Vsnet Debugging
Xml
Xsl
Scripting Jscript
Scripting Visual Basicscript
Scripting Wsh
Smartphone Developer
Visual Basic Com
Visual Basic Controls
Visual Basic Crystal
Visual Basic Database Ado
Visual Basic Syntax
Visual Basic Winapi
Vc Atl
Vc Debugger
Vc Language
Vc Mfc
Vc Stl
Visio Developer Visual Basica
Windowsce Embedded Vc
Windows Powershell
Visual Basic Vista Compatibility
Deployment Server
.NET Micro Porting

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft Scripting Visual Basicscript Posts  Ask A New Question 

VBscript embed images in HTML email body

sumit.halde posted on Wednesday, March 21, 2007 1:12 AM

Hi
Im sending email's using the "script task" of SQL Server 2005
Integraton Services. The email body is an HTML string . Now i want to
embed image in that body.I tried to do that by downloading the CDO
library ( CDOEX.dll ) but could not add it to the script task ( was
not able to add the cdoex.dll file to the refference of that script) .
Can anybody help me on the same ( either how to add a .dll file in
SSIS script task or any other way to embed image using vbscript to an
html email body)
reply

 

I don't know anything about "SQL Server 2005Integraton Services" so I don't

mayayana posted on Wednesday, March 21, 2007 9:52 AM

I don't know anything about "SQL Server 2005
Integraton Services" so I don't know how you're doing
it. I assume that you want a simple solution like

OtherComponent.AddFileToThisEmail

I can't offer any help in that case.

If you actually want to do it "by hand" you can.
It requires converting your binary file to Base64 and
then adding that text to the end of the email. The format
varies slightly depending on whether you actually want a
displayed image or an attachment. That approach
can be done without needing any extra component, but it
requires getting into the details of email structure.
reply


Previous Microsoft Scripting Visual Basicscript conversation.