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
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
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 ...
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
The quickest method would be to print to a PDF file if you have Adobe Acrobat ...
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
Try this ...
Thanks Digita,
But actualy, I'm looking for how to export Calendar with event on it.
Once Thanks all for support.
@: You are vietnamese?
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
@ geekgirlau:
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
Check your DATE format, I ran into the same problem until I change it to "mm/dd/yyyy"
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.
Office 2010, Windows 7
goal: to learn the most efficient way
Yes, I increased the "CalDates" range, this solved the problem.
Originally Posted by JKwan
Could you give more on this? I have change all DATE formate in excel file to your recommendation, but no effect.
Tks
Try this amendment:
Made a change here to capture recurring appointments as well ...
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
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.
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..
Dear all,
I currently reuse this file, and the antivirus inform me that the file content virus?
Below is the alert
Can any one help on this?Possibly infected: virus Email-Worm.Win32.NIQIM (modification) D:\Downloads\ShowAppointments.xls 36 KB 5/28/2008 2:03:24 AM
Thanks in advance.