Ask Software Development Questions and Get Answers ASAp
My name is*****'m a certified computer professional with 15 years of experience. It would be my pleasure to assist you with this May I ask what version of Outlook you are using and what version of Excel?
I am providing detailed instructions for a method that does not involve exporting but rather cutting and pasting. It will work with any version of Microsoft Office. Please give this method a try and let me know if it works for you and includes the recurring meetings.
Create a view that contains the fields you need, then copy the rows and paste into any application that accepts paste. Some applications, like Word, require Paste Special, As Text to remove OLE formatting. Otherwise, you'll paste Outlook items, not rows of text.
Use Format Columns to change the format of the date or number fields. To open the format columns dialog, right click on the row of field names and choose View Settings, Format Columns
You can paste into any application that accepts paste, however if you paste in Word, you need to use Paste Special, As Text.
If this information is helpful to you, kindly take a moment to rate my service. You can provide a rating by clicking on the stars and then clicking on submit. If this solution doesn't work for you, or if you need more help, please let me know so we can continue to work together. Your complete satisfaction is my goal! Thank you!
OK. Thank you for that information. Did the recurring meetings show up? If so, we can continue working on this. If not, we'll go back to a traditional export.
That could very well be the issue. How is the date formatted for the the recurring meetings in the Outlook calendar?
Yes, that should help. However, it may be easier to manipulate your view before you do the cut and paste. You should be able to create a calendar view that shows only this years meetings.
To modify the view of your calendar, open your calendar and then click on the View tab of the Ribbon. Next, choose Change View and select List to create a tabular arrangement of all the data in your calendar. With that View open, click View Settings near the far left side of the View tab of the Ribbon and choose Filter. On the Advanced tab of the Filter dialog box, click the drop-down arrow next to Field and choose Frequently Used Fields, followed by Start. For your Start filter, set that equal to one of the fiscal periods you wish to define – say January 1 for Period 1. Repeat the process by adding an End date to your filter – say February 4 for Period 1.
After clicking OK, return to View Settings and note that you can customize many other options, including formatting, the columns that appear in the table, etc. Once you have finished filtering and customizing, click the Change View icon on the View tab of the Ribbon and choose Save Current View as New View with a name similar to “Period 1.” Saving this view saves these settings so you will not have to establish them again for the same period. Of course, repeat the process above for as many fiscal periods as you wish to define and, upon doing so, you will be able to see all of your calendar entries for a given fiscal period just by selecting the desired view from View Settings.
I feel certain that it has to do with the date format of the recurring meetings. Could you try doing the cut and paste method separately (into 2 different sheets) for the one-time meetings and the recurring meetings and let me know the results.
OK. I apologize but I am out of ideas. I will "opt out" and see if someone else can help.
Hello, my name is ***** ***** I would like to assist you. I am reviewing everything that Alison tried with you and will respond with more information shortly.
I believe that a phone call would be the fastest and easiest way to resolve your issue and I have offered a phone call as an Additional Service. This is optional, and if you choose not to do this, I can try to find a way to help you here.