Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2016, 01:49 PM
RLAlura RLAlura is offline Trying to generate a Documents with the date for every day of the year. Windows 7 64bit Trying to generate a Documents with the date for every day of the year. Office 2010 32bit
Novice
Trying to generate a Documents with the date for every day of the year.
 
Join Date: Jan 2016
Posts: 2
RLAlura is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-28-2016, 02:10 PM
macropod's Avatar
macropod macropod is offline Trying to generate a Documents with the date for every day of the year. Windows 7 64bit Trying to generate a Documents with the date for every day of the year. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 01-28-2016, 02:57 PM
RLAlura RLAlura is offline Trying to generate a Documents with the date for every day of the year. Windows 7 64bit Trying to generate a Documents with the date for every day of the year. Office 2010 32bit
Novice
Trying to generate a Documents with the date for every day of the year.
 
Join Date: Jan 2016
Posts: 2
RLAlura is on a distinguished road
Default

Worked like a charm. THANK YOU VERY MUCH!!
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft