|
|
|
|
|
|
|
|
|
|
|
|
|
|
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."
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
Centrally managed library houses boilerplate template for repetitive person-to-person email
COPY-and-PASTE from SENT ITEMS is a crude approach to repetitive email tasks, yet we all do it at times. Now, a slick online alternative saves time for senders, assures brand consistency, and greatly improves the quality of outgoing written communications.
This service is built around a powerful integrated mail-merge functionality and is super easy for users and administrators. Use it internally, with home-based employees, or externally with dealers, distributors, service-reps, etc.
Learn more and try our LIVE DEMO. |
|
|
|
|
|
The Power Magazine for Microsoft Outlook and Exchange Users at OutlookPower.com
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide. Outlook is a trademark of Microsoft Corporation.
|
|
|
|
|
|
|