Solved

Creating a Dynamic Email Signature with content from SQL

Posted on 2009-04-02
11
793 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
ID: 24058616
How do you send the emails? Where do you put this signature code?
0
 

Author Comment

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

Joe
0
 

Author Comment

by:joedarwin
ID: 24060303
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
ID: 24060360
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
ID: 24060380
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 83

Expert Comment

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

Author Comment

by:joedarwin
ID: 24060526
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
ID: 24060683
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
ID: 24060789
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
ID: 24063283
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
ID: 24063384
OK, thanks for the comments, i will await some other comments.

have a good one.
Joe
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
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…

920 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

17 Experts available now in Live!

Get 1:1 Help Now