Converting monthly calendars in Outlook to [editable] Word format

I have a requirement to send out editable monthly schedules in a whole month calendar format. Outlook 2007 provides the perfect blank calendar, since it already has parts of my schedule in it.

The problem is that I cannot find a way to save this calendar into Word format. That's a little bit ironic considering they are both MS products.

I've tried the following (and failed):
- In Outlook Cal mode, there is no import/export (for a Calendar)
- Save as web page, displays a different format, also can't be opened correctly in Word

I also have a PDF print driver (pdfFactory Pro - great program BTW). Printing to a PDF file gets me quite close to what I want to achieve. What I mean is that the PDF format retained all text AS TEXT. This is good but unfortunately, I have no way to convert the PDF into Word format (where text stays as text). I own Adobe Acrobat Pro but ever format conversion available converts the entire calendar to a graphic image; USELESS!

I have also tried http://www.pdftoword.com/Default.aspx but despite 5 attempts, nothing is sent back to me. No, it is not going into my SPAM folder. Next, I downloaded their Nitro PDF Pro software, unfortunately, the conversion jumbled all the text to the left side of the page; useless!

A relatively simple task like this should be so difficult!

At this point, I will accept nearly anything that ultimately gets me a monthly calendar [as shown below] where 8pt text can be entered into each day field from Word (and can be printed).

I attached a sample PDF (output from Outlook 2007) and a jpg to show the calendar layout that I require.
Any suggestions?
june2009cal.jpg
Monthly-Style-June09.pdf
LVL 4
S ConnellyTechnical WriterAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joanne M. OrzechManager, Document Services CenterCommented:
There's an excellent Outlook calendar template that should do just about everything you need.  Even though it says it's for Word 2000, I've used it with 2007.  It can be downloaded at:
http://support.microsoft.com/default.aspx/kb/201567

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
S ConnellyTechnical WriterAuthor Commented:
Thanks JOrzech. I downloaded this but unfortunately it is written in VB script from the days of Outlook 97. Consequently, it doesn't quite work... meaning, it displays a calendar for Jan. 2009 only.

If I have some time, I might look at the code and see if I can modify it (my VB coding is very rusty though... haven't done that in 6 years).

BTW, I should also point out that I attempted to download some of the apparently excellent calendars available in MS Office online templates (select New from Word). But there must be something wrong with Office Online b/c I just get a "Template Download Error". What's up with that?
0
Joanne M. OrzechManager, Document Services CenterCommented:
I don't understand what you mean.... did you double-click the template?  Because you can tell it the date range you want it to create.  See the image below which is what you SHOULD get when you access the template.



Outlook-Calendar.gif
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Joanne M. OrzechManager, Document Services CenterCommented:
As for the second part of your question why you are having problems downloading templates, you should probably download the ActiveX control
http://office.microsoft.com/en-us/help/HP010349411033.aspx
0
S ConnellyTechnical WriterAuthor Commented:
Actually, I took many tries... but I was able to download some templates. I think there is something 'wonky' between my connection and Microsoft. Anything else Internet related works so it's not specifically a problem at my end.

In regards to the calendar template, yes I do get the menu (after I enable macros) but no matter which month I select, I only get a January 2009 calendar. Are you using Word 2007?

Anyhow, as much as it would be nice use this template and to extract data from the Outlook calendar... I was able to successfully download some nice calendars from Office Online.

FYI,
I found a nice free Calendar creator: http://www.calendarlabs.com/printable-calendar.php
I don't need it but this might be useful to someone else.
0
Joanne M. OrzechManager, Document Services CenterCommented:
I have both Word 2003 and Word 2007 installed on my machine and the template I gave you works fine on both.  I don't know why it wouldn't work properly on yours.  In any event, I'm glad you were able to get some downloads that will serve your purpose.

I assume you had to download the ActiveX at the link I posted?
0
S ConnellyTechnical WriterAuthor Commented:
>I assume you had to download the ActiveX at the link I posted?

No, I don't have an issue with ActiveX. It was simply a communication problem.

>I have both Word 2003 and Word 2007 installed on my machine and the template
>I gave you works fine on both.  

Odd, it certainly doesn't do anything more than display a Jan. 2009 calendar.
0
Stacy BrownSenior Applications AdministratorCommented:
Sounds like the problem is with the Macro security settings.  You could try changing the Security Level setting to Low and on the Trusted Publisheres tab checking both "Trust all installed Add-ins and Templates" and "Trust access to Visual Basic Projects" .  You'll find these settings under Tools | Macro | Security.
0
S ConnellyTechnical WriterAuthor Commented:
Thank you everyone! :-)
0
Joanne M. OrzechManager, Document Services CenterCommented:
Great.  Glad to have been of assistance.  Thank you.

Joanne Orzech
MS Word MVP
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.