Solved

Creating a Dynamic Email Signature with content from SQL

Posted on 2009-04-02
11
786 Views
Last Modified: 2012-05-06
I have seen recently some emails that contain dynamic content in forum signatures and sometimes email signatures.

I would like to create an image that can be used in an email signature or forum signature that is getting real time data stats for a particular user and display that in this image.

http://www.mydomain.com/mysig.jpg?user

Something like the above URL would generate a .jpg file that can be used in both email and forums.

Here is some code that we use in our email signatures currently, but this pulls from feedburner only shows an RSS feed.  I want to pull content about a particular user
<a href="http://feeds2.feedburner.com/~r/EvgaNewsRssFeed/~6/1"><img src="http://feeds2.feedburner.com/EvgaNewsRssFeed.1.gif" alt="EVGA News RSS Feed" style="border:0"></a>

Any help is greatly appreciated.

Thanks
Joe
0
Comment
Question by:joedarwin
  • 6
  • 5
11 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
How do you send the emails? Where do you put this signature code?
0
 

Author Comment

by:joedarwin
Comment Utility
The signature code will go in the outlook 2003 client or will be HTML code for forums signatures.

Joe
0
 

Author Comment

by:joedarwin
Comment Utility
here is a sample for the forums postings.
If you look at the first post signature you will see that many people use this, we want to be able to do something similar with our own graphics and content.

http://www.evga.com/forums/tm.asp?m=392442&mpage=40

this is the code to get the dynamic image
http://piro.pirocast.net/badge/fah01/fah01/1/0/0/0/0/0/0/4/0/255/4/0/255/255/255/255/434022.png

Thanks and look forward to seeing what we need.

Joe Darwin

0
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
I understand that but i do not understand is where would you do this with both emails and forums. I mean you could add the signatures to the forum posts in the aspx page that is used to post message in the forum. The signature to the emails would depend on whether you send emails using outlook or using your own program. I have developed a VBScript which runs on each user login and creates an email signature in the outlook which is automatically added to each email for each user.
0
 

Author Comment

by:joedarwin
Comment Utility
The email signature will be added in the options of outlook client similar to the feedburner and will pull content from an RSS feed or from a database pull.
Joe
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
Then you have to do it through a script or through vb.net
0
 

Author Comment

by:joedarwin
Comment Utility
I understand i am going to need a script or some sort of software, that is what i am trying to find out.  I am not a programmer, i have this request from my marketing and trying to figure out how they do it and what i need on ourservers and is there any samples that anyone has done for ASP.net to do this.

Thanks
Joe
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
Comment Utility
You can set the signatures for the forums in the asp.net page that posts to the forum. If you show us the code of that page, we may be able to modify it. For the Outlook, you can either buy products like Exclaimer which would not only add signatures to emails going from the exchange server but would provide many other features. Or you could use this script
Set objSysInfo = CreateObject("ADSystemInfo")
 

strUser = objSysinfo.UserName
 

Dim objUser

Set objUser = GetObject("LDAP://" & strUser)

strName = objUser.FullName

strTitle = objUser.Title

strPhone = objUser.Mobile

strDept = objUser.Department
 

'Dim oILPic 
 
 

Set objWord = CreateObject("Word.Application")

objWord.Visible = false
 

Set objDoc = objWord.Documents.Add()

Set objSelection = objWord.Selection
 

Set objEmailOptions = objWord.EmailOptions

Set objSignatureObject = objEmailOptions.EmailSignature
 

Set objStyle = objEmailOptions.ComposeStyle
 

objStyle.Font.Name = "Century Gothic"

objStyle.Font.Size = 10
 

Set objReplyStyle = objEmailOptions.ReplyStyle

objReplyStyle.Font.Name = "Century Gothic"

objReplyStyle.Font.Size = 10

objReplyStyle.Font.Color = wdColorBlack

 

Set objSignatureEntries = objSignatureObject.EmailSignatureEntries
 

objSelection.TypeText "Regards,"

objSelection.TypeParagraph()

objSelection.TypeParagraph()

objSelection.TypeText strName

objSelection.TypeParagraph()

objSelection.TypeText strTitle

objSelection.TypeParagraph()

objSelection.TypeParagraph()

objSelection.TypeText "(t)  0115 919 1111"

objSelection.TypeParagraph()

if Len(strPhone)>0 then

objSelection.TypeText "(m)  " & strPhone

end if

objSelection.TypeParagraph()
 

Set objSelection=objDoc.Range()

objSelection.Font.Name = "Century Gothic"

objSelection.Font.Size = 10
 
 

Set objSelection=objDoc.Range()
 

objSignatureEntries.Add "AD Signature", objSelection

objSignatureObject.NewMessageSignature = "AD Signature"

objSignatureObject.ReplyMessageSignature = "AD Signature"
 

objDoc.Saved = true

objWord.Quit

msgbox "Done"

Open in new window

0
 

Author Comment

by:joedarwin
Comment Utility
We already use the exclaimer utility, that is where i want to put the code to display an image like:
http://piro.pirocast.net/badge/fah01/fah01/1/0/0/0/0/0/0/4/0/255/4/0/255/255/255/255/434022.png
but I dont know how to create the code like the website pirocast.net did.

i will try to explain again what we are looking for.

I am looking for a page on our site that can run just like the URL above does, but host it on our servers and generate a dynamic png or jpg or gif file does not matter with dynamic content from our database.

Joe
0
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
I dont think that is anything to do with what we have been discussing. I would think that is a HTTP Handler module used to generate the images on the fly.
0
 

Author Comment

by:joedarwin
Comment Utility
OK, thanks for the comments, i will await some other comments.

have a good one.
Joe
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now