How to get date in mail merge as in excel

In a mail merge, you can insert the current date using a special field called TODAY() in Microsoft Word. Here's how:

Step 1: Create a new mail merge document in Word

• Open Microsoft Word and create a new document.
• Go to the "Mailings" tab in the ribbon.
• Click on "Start Mail Merge" and select "Step-by-Step Mail Merge Wizard".
• Follow the wizard to create a new mail merge document.

Step 2: Insert the TODAY() field

• In your mail merge document, place your cursor where you want to insert the current date.
• Go to the "Insert" tab in the ribbon.
• Click on "Quick Parts" and then "Field".
• In the "Field names" list, select "TODAY" and click "Insert".
• The TODAY() field will be inserted into your document.

Step 3: Format the date (optional)

• If you want to format the date in a specific way, you can use the "Format" button next to the TODAY() field.
• Select the format you want to use from the list of available formats.

Step 4: Merge your document

• Once you've inserted the TODAY() field, you can merge your document with your data source (e.g. an Excel spreadsheet).
• Go back to the "Mailings" tab and click on "Finish & Merge".
• Select "Edit Individual Documents" to merge your document with your data source.

Tips:

• The TODAY() field will update to the current date every time you merge your document.
• You can also use other date-related fields, such as NOW() (which includes the time) or DATE() (which allows you to specify a specific date).
• If you're using an Excel spreadsheet as your data source, you can also use Excel formulas to insert the current date, such as =TODAY().