Share via

I would like to put current date in format dd-MMM-yy in th subject line of a custom form in Outlook

Kovachev, Viktor 1 Reputation point
2022-10-05T08:17:04.323+00:00

Hey All,
I am trying to create a custom form in Outlook and would like to put standard text and the current date (in format dd-MMM-yy for example 05-Oct-22) in the subject line of the form.
Up until now I was able to put "Standard text" & Date() which returns Standard text 10/05/22.
How can I do it like "Standard Text 05-Oct-22"?

Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,072 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ChristyZhang-MSFT 22,336 Reputation points Microsoft Vendor
    2022-10-06T03:12:25.84+00:00

    Hi @Kovachev, Viktor ,

    Welcome to our forum!

    Do you mean that you want to add a table in Outlook with the format "Standard Text 05-Oct-22", right?

    If so, please refer to the following steps:
    1.Click Table>Excel Spreadsheet.
    247965-17.png

    2.Type the date and select this column, right and click Format Cells...
    247966-18.png

    3.In Format Cells window, click Number>Date>14-Mar-12 as shown in the below figure, and click OK.
    247933-19.png

    4.Then the format "06-Oct-22" will be displayed. You just need to complete the forum in the Excel Spreadsheet.

    Hope to help you!

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Kovachev, Viktor 1 Reputation point
    2022-10-06T07:11:16.367+00:00

    Hi @ChristyZhang-MSFT , this is not in Excel, I have described it in the subject: "Custom Form in Outlook",
    Please see:
    "I am trying to create a custom form in Outlook and would like to put standard text and the current date (in format dd-MMM-yy for example 05-Oct-22) in the subject line of the form.
    Up until now I was able to put "Standard text" & Date() which returns Standard text 10/05/22.
    How can I do it like "Standard Text 05-Oct-22"?"