Help: Export OutLook Calendar in Excel Table/word Table form

[yurble_vn]

I'm very new in VBA and Outlook.

Just wonder is there anyway to export Outlook Calendar to Word or Excel table, so I can send it out easily

Please help

Thanks

[geekgirlau]

In Outlook, selecting File | Import and Export allows you to export the calendar file between date ranges to Excel or Word. It also allows you to customise the fields that are exported.

I haven't looked at this via code, but I think the first step would be to clarify whether this method will give you the data you want ...

[yurble_vn]

Thanks geekgirlau,

Maybe I have not clearly expressed my idea.

By saying table, I mean to export the calendar in form of an actual calendar. What I'm trying is to export a Calendar table look like what we see in Outlook calendar.

Thanks for prompt support

[geekgirlau]

The quickest method would be to print to a PDF file if you have Adobe Acrobat ...

[Digita]

Chao ban,

Welcome to VBAExpress. I don't use outlook so I can't help you with your question. However, if you want to have a calendar in XL the enclosed file would help.

Regards


Phong

[geekgirlau]

Try this ...

[yurble_vn]

Thanks Digita,

But actualy, I'm looking for how to export Calendar with event on it.

Once Thanks all for support.

@: You are vietnamese?

[yurble_vn]

Thanks Digita,

But actualy, I'm looking for how to export Calendar with event on it.

Once Thanks all for support.

@: You are vietnamese? Nice to meet you here

[yurble_vn]

@ geekgirlau: (http://vbaexpress.com/forum/member.php?u=450)

It works find for some month, but in the other it collect all the event in the calendar and put it in the one day.

Thanks for this :)

[JKwan]

Check your DATE format, I ran into the same problem until I change it to "mm/dd/yyyy"

[TrippyTom]

Hey, that's pretty cool.

I noticed a bug when the month goes into a 6th row (rare, but it does happen sometimes).

For instance, try it for September of 2007, then do October of 2007. The last day of September still stays.

[JKwan]

Yes, I increased the "CalDates" range, this solved the problem.

[yurble_vn]

Check your DATE format, I ran into the same problem until I change it to "mm/dd/yyyy"


Could you give more on this? I have change all DATE formate in excel file to your recommendation, but no effect.

Tks

[geekgirlau]

Try this amendment:

[geekgirlau]

Made a change here to capture recurring appointments as well ...

[yurble_vn]

That's great Geekgirlau, thanks for your support and effort...

Just a small concern:
1. What E3 stand for??
2. Can we have six line instead of five? so Month start on sun/sat 30th/31st days don't have to be break to first line
3. In case you free to think: can we expand to 2,3,4 months?

Once again, thanks

[geekgirlau]

I've adjusted this to continue down to 6 lines and fixed up the E3 - I'll see if I have time later to expand the months.

[yurble_vn]

Many thanks Geekgirlau,

Actually, I could not ask for more from what you have supported. Take it easy and kindly recieve my hearted thanks...

Thanks..

[yurble_vn]

Dear all,

I currently reuse this file, and the antivirus inform me that the file content virus?
Below is the alert

Possibly infected: virus Email-Worm.Win32.NIQIM (modification) D:\Downloads\ShowAppointments.xls 36 KB 5/28/2008 2:03:24 AM


Can any one help on this?

Thanks in advance.