Automatic, updating email signatures (Page 2)

Search OutlookPower's 9,596 Outlook and all-things-email article archive

Home
EasyPrint
News details

Articles-only

Twitter Feed

Automatic, updating email signatures (continued)

It doesn't get much easier than that. Here's an example of what the code might look like.

Disclaimer: A trained professional did NOT write this code. By all means, attempt this at home.


    RTFPath = SIGPath & "Temperature.rtf"



    If CurrentTemp <> "N/A" Then

        fPos = InStr(CurrentTemp, "F")

        If fPos <> 0 Then

            TempOnly = Mid(CurrentTemp, 1, fPos - 3)

            fPos = InStr(CurrentChill, "F")

            If fPos <> 0 Then

                ChillOnly = Mid(CurrentChill, 1, fPos - 3)

'''''''''''''''''''''''''''''''''''''

' Do RTF signature

'''''''''''''''''''''''''''''''''''''

                Temp2 = "\viewkind4\uc1\pard\qc\i\fs20 "

                Temp2 = Temp2 & "Temperature " & TempOnly & "\'b0 F, Feels Like "

                Temp2 = Temp2 & ChillOnly & "\'b0 F\par"

                RTFStrings(2) = Temp2



                Open RTFPath For Output As #intFNum



                For X = 1 To 4

                    Print #intFNum, RTFStrings(X)

                Next X

                Close #intFNum

            End If

        End If

    End If

For the people who want to know how much daylight I'm getting, I threw together a .csv file that contains sunrise/sunset data. Another little Visual Basic program reads the data for the current day and updates the Outlook signature used for new email messages. I run this as a Scheduled Task, as it only needs to be done once a day. On a new email, the recipient will see something like below.

Sunrise/Sunset data for: 09/16/2004 Sunrise: 7:30AM, Sunset: 8:16PM Total daylight: 12 hours, 46 minutes Records for this date: High 70 (1919), Low 26 (1935)

If you're reading this and say to yourself, "I wanna do what he did!" you can save yourself a lot of headaches, not to mention money, if you get your neighbor to invest in an online weather station instead of trying to do it yourself. In my particular case, the weather station already existed -- I just took advantage of it.

In all fairness to my neighbor, he's spent considerable money in keeping his weather station upgraded and operational, and for that I'm eternally grateful. Especially the times when they changed the wind chill formula (requiring an upgrade), or when I complained that his wind gauge froze up and asked if he could upgrade to a heated one. If you're successful in getting your neighbor to install an online weather station, three words of advice: BE ETERNALLY GRATEFUL!

The third question I alluded to earlier is this, and I swear I'm not making this up!

"I read once that a bald eagle snatched up a five year old girl and flew away with her. Does that happen in Alaska?"

Not wishing to let someone this gullible off so easily I replied, "Yes. It happens all the time. Five year old girls are very scarce in Alaska because bald eagles patrol the neighborhoods and hang out at gymnastic clubs and ice skating rinks, places where five year old girls are known to go."