Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-16-2015, 05:15 AM
TechieHell TechieHell is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Mar 2015
Posts: 2
TechieHell is on a distinguished road
Default Word signatures w/ date stamp

Hi all,

I was wondering if I could call on your collective intellect.

A user of ours is looking for a method to create a text field in Word in which a person can type their name, and a time/date stamp is automatically added.

This is going to be used as a method for digital signatures, to save printing, using a pen to sign the doc, and scanning it.

I've had a play with track changes but concluded that macros would be the way, as apparently the person had used them for that in a previous job.



Macros might as well be in Klingon to me though, so any help would be absolutely pukka.

Cheers

Last edited by Charles Kenyon; 03-16-2015 at 08:04 AM. Reason: Mark as solved
Reply With Quote
  #2  
Old 03-16-2015, 05:53 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,705
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

You can certainly insert the username, time and date into a document using VBA, though it would have no security value.

Code:
Sub InsertNameAndDate()
    Selection.TypeText Environ("UserName") & Chr(32) & Chr(150) & Chr(32) & _
                       Format(Date, "Long Date") & Chr(32) & Chr(150) & Chr(32) & _
                       Format(Time, "HH:MM")
lbl_Exit:
    Exit Sub
End Sub
You could include a scanned signature graphic, but that would not improve security either, and you would need to arrange a selection of images one for each user.

This is not a substitute for digitally signing a document.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-16-2015, 07:24 AM
TechieHell TechieHell is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Mar 2015
Posts: 2
TechieHell is on a distinguished road
Default

Thank you my friend- that is just what I was looking for!

I've let them know that it isn't too secure, but it's made them happy so my work is done.

All the best
Reply With Quote
Reply

Tags
macro, signature, word 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Eliminate time stamp in Track Changes Aden Word 17 03-06-2017 01:24 AM
Updating time stamp only when changes have been made and re-saved ashmo0024 Word 1 09-05-2014 01:46 PM
Outlook 2003-formatting vba Date stamp Royzer Outlook 0 03-29-2012 10:39 AM
Signatures rob75 Outlook 3 05-18-2011 05:02 PM
Add date and time stamp to new mail and incoming mail cadsmarter Outlook 0 02-02-2006 08:50 AM


All times are GMT -7. The time now is 01:05 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft