Nov 23, 2008 Rather than spend extra money on specialized journal or diary software, you can use Microsoft Word. In Microsoft Word. Templates for Microsoft Office. Microsoft Office 2016 Preview. Microsoft Office 2011. Word Diary Template Creator; Word Diary Template Creator $19.95. Download Now Secure Download. Editors' Rating. 2018 yearly calendar (Sun-Sat) Word 12-month Calendar (Mon-Sun) Word 12-month Calendar (Sun-Sat) Word 2018 photo calendar (Sun-Sat) PowerPoint 2018 calendar (Mon-Sun) PowerPoint 2018 calendar (Mon-Sun, two-ring design) PowerPoint 12-Month Calendar Excel 2017-2018 academic calendar Word. A simple way to do it is to start with an Excel Workbook. On Sheet 1, in Cell A1, insert the word 'Date' In Cell A2, insert the formula =Today() In Cell A3, insert the formula = A2+1 Then copy that formula down as many rows as required. Then save this workbook and then in Word, with a new document on the screen, go to the Mailings tab of the ribbon and click on the Start Mail Merge dropdown in the Start Mail Merge section of the ribbon and select 'Letters'. Then, click on Select Recipients and then on Use Existing List and then navigate to, and select the Excel Workbook that you created, selecting Sheet 1 as the source of the data. Then, in the Word document, with the selection where you want the date to appear, using the Insert Merge Field dropdown, select the Date field and insert it into the document. Add any other text that you want to appear on each page, and save this document, which will be your Mail Merge Main Document. Then, with that document as the active document, in the Finish section of the Mailings tab of the ribbon, click on Finish & Merge and select Edit Individual Documents. When the process has finished running, you will have a document that contains a page for each day with the date where you inserted the merge field. If the date is not in the format that you want it, modify the «Date» field in the Mail Merge Main document, following the procedure in the article 'Formatting Word fields with switches' on fellow MVP Graham Mayor's website at: Keep the Excel Workbook and the Mail Merge Main document as you can use them again when you want to create more pages. Just opening the Excel Workbook and recalculating it will cause the =Today() field to update to the current day and likewise all of the dates in the cells below it will be updated. Another way to do it is to down load fellow MVP Macropod's Word Date Calculation Tutorial from: and extract the file from the archive and then on Page 11, copy the range of dates that are highlighted in the following screen shot: and paste them into a new document. Then starting with the second date, select it and the rest of the dates and copy and paste them as many times as required. Then press CTRL+a to select every this and then press F9 to update the date. Finally, select everything except for the first date and format the paragraphs to have a page break before them. Hope this helps, Doug Robbins - Word MVP [email protected] I AM NOT CONCERNED ABOUT MY EMAIL ADDRESS BEING VISIBLE!!!! Disclaimer The sample scripts are not supported under any Microsoft standard support program or service. The sample scripts are provided AS IS without warranty of any kind.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |