Forum Discussion
How to add auto dates
Hooksquestions The simplest way is to create a data source in Excel that includes a column of dates - Insert the word Date into cell A1, format the column with the required date format, insert the first date into cell A2, in cell A3, insert the formula =A2+1 and then copy that down the column.
Then, save the file.
Then in Word, create a document with a page for each vehicle, from the Start Mail Merge dropdown in the Start Mail Merge section of the Mailings tab of the ribbon, select Letters. Then use the Select Recipients facility to select the workbook containing the dates and then insert the Date mergefield on each page of the document where you want the dates to appear. Save the document and then select Edit Individual Documents from the Finish & Merge dropdown in the Finish section of the Mailings tab of the ribbon to create a document that has a page for each vehicle with the dates for as many dates as you had in the Excel data source. Alternatively, execute the mail merge to the printer.