Hello,

I am trying to generate a document with a template, and have it insert a page with a copy of the template page, containing the date for every day of the year for 2016.

I've done a few things in VBA, but I'm a little out of my depth.

I have my template page, i just need to know what I need to get it to input each date from Jan 1 to December 31 on each individual page as it adds it.

I also have each date in an excel file, if I can pull the data directly from that.

Let me know what you think. I'm open to any suggestions.

Thanks,

-Ray

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

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Worked like a charm. THANK YOU VERY MUCH!!