Solved

Creating a Dynamic Email Signature with content from SQL

Posted on 2009-04-02
11
801 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
  • 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
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…

815 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

10 Experts available now in Live!

Get 1:1 Help Now