#1
|
|||
|
|||
Trying to generate a Documents with the date for every day of the year.
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Worked like a charm. THANK YOU VERY MUCH!!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
How to search for a specific year from a table with year range? | Wii | Excel | 0 | 05-05-2015 12:40 PM |
How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
Inserting “date & time” for the year (YYYY) only, | Jamal NUMAN | Word | 5 | 07-19-2014 06:42 PM |
How to count year lapse (rounded off) based on specific date | KIM SOLIS | Excel | 1 | 11-01-2011 10:50 AM |