The simplest way is via a letter mailmerge, where your excel workbook has a column full of dates. No VBA required, and the dates will be positioned exactly where you want them. To control the mailmerge date formatting, see
Mailmerge Date Formatting in the
Mailmerge Tips & Tricks thread:
https://www.msofficeforums.com/mail-...ps-tricks.html