VBA to Auto Insert Date and Time in the signature

Status
Not open for further replies.

DDB

New Member
Outlook version
Outlook 2013 64 bit
Email Account
IMAP
I have searched several hours looking for a method to have my email signature include the date and time fields so that when a new email is started the email signature in the body shows the current date and time. No such luck.
Is there a VBA method to accomplish this task? I have tried adding directly to the signature but that does not help.
Any help would be much appreciated.
 
You can do it in a signature but it's a 2-step process - you need to select all, the update fields. The other option is a macro to add the time/date - maybe as an 'after sending' macro that adds it as its sent. It's usually easier if you have placeholders such as [date] - but if the macro fails (or if using a manual macro, you forget to run it), it will be sent with the placeholder.

Create the signature in a new message - Alt+F9 to view the codes - Copy the signature.

In the signature dialog, paste the copied text.

Save.

In the message: Select all (Ctrl+A, right click and choose update code. F9 was not working for me to update - only the right-click method.

Steps in the screenshot:
  1. The sample signature in a new message.
  2. Select all, Copy and Paste into the signature editor.
  3. The signature in a new message.
  4. Select all, update field. (F9 was not working to update it.)
  5. The updated signature.

2021-07-19_08-27-26-0000.png
 
This article demonstrates the placeholder method - its for sending autoreplies using a rule, but the same method could be used in a macro to update placeholders in the signature.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
M VBA Auto-Reply code for Two Mailboxes on one Outlook Session. Outlook VBA and Custom Forms 4
N VBA, Rule that will Auto Reply based on time of day Outlook VBA and Custom Forms 1
D VBA script to auto download attachments and rename file according to subject line Outlook VBA and Custom Forms 23
B Auto BCC VBA macro: how to add exceptions? Using Outlook 28
H using VBA to edit subject line Outlook VBA and Custom Forms 0
G Get current open draft message body from VBA Outlook VBA and Custom Forms 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
V VBA Categories unrelated to visible calendar and Visual appointment Categories Outlook VBA and Custom Forms 2
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
R Outlook 2019 VBA to List Meetings in Rooms Outlook VBA and Custom Forms 0
geoffnoakes Counting and/or listing fired reminders via VBA Using Outlook 1
O VBA - Regex - remove double line spacing Outlook VBA and Custom Forms 1
D.Moore Strange VBA error Outlook VBA and Custom Forms 4
B Modify VBA to create a RULE to block multiple messages Outlook VBA and Custom Forms 0
D Outlook 2021 Using vba code to delete all my spamfolders not only the default one. Outlook VBA and Custom Forms 0
D VBA - unable to set rule condition 'on this computer only' Outlook VBA and Custom Forms 5
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
BartH VBA no longer working in Outlook Outlook VBA and Custom Forms 1
W Can vba(for outlook) do these 2 things or not? Outlook VBA and Custom Forms 2
MattC Changing the font of an email with VBA Outlook VBA and Custom Forms 1
P MailItem.To Property with VBA not work Outlook VBA and Custom Forms 2
P Tweak vba so it can target another mailbox Outlook VBA and Custom Forms 1
A Outlook 2010 VBA fails to launch Outlook VBA and Custom Forms 2
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
TedSch Small vba to kill political email Outlook VBA and Custom Forms 3
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
Z VBA Forward vs manual forward Outlook VBA and Custom Forms 2
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A Any way to force sort by/group by on search results with VBA? Outlook VBA and Custom Forms 1
E Default shape via VBA Outlook VBA and Custom Forms 4
A Change settings Send/receive VBA Outlook VBA and Custom Forms 0
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
justicefriends How to set a flag to follow up using VBA - for addressee in TO field Outlook VBA and Custom Forms 11
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
D VBA code to select a signature from the signatures list Outlook VBA and Custom Forms 3
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2

Similar threads

Back
Top