Can I create a calendar and import data from a table into it?

[mjreale]

I have a Word Table that contains, among other items, dates (e.g, 5/14), day
of the week (e.g., Tues), and another column of data. Is there a way to
created a monthly calendar that would use these three items and automatically
create a calendar, entering the information in the column of date into the
correct day of the month?

 

[Jay Freedman]

Taking the question literally, it is possible. However, to my knowledge
there is no pre-packaged solution for anything like it. You would need these
ingredients:

- Choose or create a calendar template with the appearance you like. There
are a lot of calendar templates at
http://office.microsoft.com/en-us/templates/CT101043131033.aspx, and many of
them are suitable for putting information into the date boxes (which are
usually just table cells).

- Write a macro to transfer the data from your existing document to a
document based on the calendar template. Although you could perhaps get a
starting point from Word's macro recorder, there are parts of it -- such as
reading a date from the source document and determining from it which cell
in the calendar is the corresponding one -- that cannot be recorded. For
that, you'll have to learn something about programming in Visual Basic for
Applications and how the "object model" (VBA's description of things in
Word) works; or you can find someone who knows how, and have them write it
for you.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.