Solved

Creating a Dynamic Email Signature with content from SQL

Posted on 2009-04-02
11
848 Views
Last Modified: 2017-02-03
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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Set up iPhone and iPad email signatures to always send in high-quality HTML with this step-by step guide.
Find out what Office 365 Transport Rules are, how they work and their limitations managing Office 365 signatures.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

724 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