• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 906
  • Last Modified:

Creating a Dynamic Email Signature with content from SQL

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
joedarwin
Asked:
joedarwin
  • 6
  • 5
1 Solution
 
CodeCruiserCommented:
How do you send the emails? Where do you put this signature code?
0
 
joedarwinAuthor Commented:
The signature code will go in the outlook 2003 client or will be HTML code for forums signatures.

Joe
0
 
joedarwinAuthor Commented:
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
Independent Software Vendors: 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!

 
CodeCruiserCommented:
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
 
joedarwinAuthor Commented:
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
 
CodeCruiserCommented:
Then you have to do it through a script or through vb.net
0
 
joedarwinAuthor Commented:
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
 
CodeCruiserCommented:
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
 
joedarwinAuthor Commented:
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
 
CodeCruiserCommented:
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
 
joedarwinAuthor Commented:
OK, thanks for the comments, i will await some other comments.

have a good one.
Joe
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now