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.
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:
The sample signature in a new message.
Select all, Copy and Paste into the signature editor.
The signature in a new message.
Select all, update field. (F9 was not working to update it.)
These code samples show you how to use a run a script rule to send an auto response, including the received date and when the recipient should expect a follow up response. The first sample uses a template for the reply, the second macro replies to the incoming message.