|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
September 16th, 2004, 01:12 PM
|
|||
|
|||
VBA: Auto Time Insert
Hey everyone... This is probably simple but I need a little help. I want to automatically insert the system time into the body of an automated outlook message. Basically I am writing a macro that send an e-mail to our receptionist to let her know when I am leaving the builiding. The simple code is as follows:
Sub Logging_Off() Set newMsg = Application.CreateItem(olMailItem) newMsg.To = "myemail.com" newMsg.Subject = "Logging Off" (THIS IS WHERE I WANT TO INSERT TIME!!) newMsg.Body = "Please sign me out" newMsg.Display newMsg.Send MsgBox ("Your E-mail was sent") End Sub What I want to accomplish is to insert the system time into the Subject of the automatically generated e-mail. I am not sure how to retrieve it and do this. Please advise! Thanks in advance for all of your help.. -Dennis
|
|
#2
September 16th, 2004, 06:00 PM
|
|||
|
|||
|
newMsg.Body = "Please sign me out as of " & now()
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > VBA: Auto Time Insert |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
