Software

Ask Software Development Questions and Get Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I am trying to export all of the meetings on a shared public…

Customer Question
Hello - I am...

Hello - I am trying to export all of the meetings on a shared public Outlook into Excel and cannot seem to get this to work. Any recommendations on how to do this?

Technician's Assistant: Sometimes things that you think will be really complicated end up being easy to fix. The Computer Technician I'm going to connect you with knows all the tricks and shortcuts. Tell me a bit more about what's going on so he can help you best.

We use Outlook for booking conference room reservations. I was hoping to import reserved meetings into Excel so that I can manipulate the data to show utilization by group, name, time, etc.

Technician's Assistant: Is there anything else the Computer Technician should be aware of?

I do not think so.

Submitted: 2 years ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Customer reply replied 2 years ago
recurring meetings seem be excluded when I sort the list in excel?
Answered in 23 minutes by:
2/19/2016
Software technician: GeekGal, Software Support Specialist replied 2 years ago
GeekGal
GeekGal, Software Support Specialist
Category: Software
Satisfied Customers: 1,709
Experience: MIS degree and 15+ years Experience in IT
Verified

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?

Ask Your Own Software Question
Customer reply replied 2 years ago
Hello - I believe it is 2013 for both.
Software technician: GeekGal, Software Support Specialist replied 2 years ago

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.

  1. Switch to a list view, if not already using a list view.
  2. Right click on the row of field names and choose Field Chooser.
  3. Drag the fields you need to copy to the row of field names.
  4. Drag the fields you don't need off of the row of field names.
  5. Begin by selecting the text. Hold Ctrl as you scroll down or use the PgDown or End key to select the items faster.
  6. Press Ctrl+C to copy the selection.
  7. Go to Excel and paste (Ctrl+V)

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.

Ask Your Own Software Question
Software technician: GeekGal, Software Support Specialist replied 2 years ago

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!

Ask Your Own Software Question
Customer reply replied 2 years ago
Well, this worked somewhat. When I paste into Excel and split the data to do a YTD tall of meetings, it doesn't come close to the count by doing a physical count on the calendar.
Software technician: GeekGal, Software Support Specialist replied 2 years ago

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.

Ask Your Own Software Question
Customer reply replied 2 years ago
they do. I think the challenge might be in manipulating the data. I am trying to get a YTD tally of meetings and I am running into issues (I think with the recurring meetings) as I try to filter by date.
Software technician: GeekGal, Software Support Specialist replied 2 years ago

That could very well be the issue. How is the date formatted for the the recurring meetings in the Outlook calendar?

Ask Your Own Software Question
Customer reply replied 2 years ago
Some have a start date as early as 2014: Mon 7/14/2014. I am doing text to columns in Excel to isolate anything that has an recurring end range prior to 2016. Would that help?
Software technician: GeekGal, Software Support Specialist replied 2 years ago

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.

Ask Your Own Software Question
Customer reply replied 2 years ago
How, please?
Software technician: GeekGal, Software Support Specialist replied 2 years ago

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.

Ask Your Own Software Question
Customer reply replied 2 years ago
I was able to do this but the count is still off by 70+ meetings.
Software technician: GeekGal, Software Support Specialist replied 2 years ago

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.

Ask Your Own Software Question
Customer reply replied 2 years ago
It is still the same result.
Software technician: GeekGal, Software Support Specialist replied 2 years ago

OK. I apologize but I am out of ideas. I will "opt out" and see if someone else can help.

Ask Your Own Software Question
Customer reply replied 2 years ago
Thank you. I am completely stumped as to why some of the meetings are not captured. Very odd.
Software technician: Gary Jensen,
 replied 2 years ago
Gary Jensen
Category: Software
Satisfied Customers: 54
Experience: Functional Systems Administrator at Hill Air Force Base, OO-ALC/309SMXG
Verified

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.

Ask Your Own Software Question
Customer reply replied 2 years ago
Hello - It appears that weekly and daily meetings are not fully captured in the list view. Multiple occurrences of daily meetings, weekly meetings, twice weekly meetings etc. are not captured. Is there a way in the View settings to account for this?
Software technician: GeekGal, Software Support Specialist replied 2 years ago

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.

Ask Your Own Software Question
Customer reply replied 2 years ago
Hello - I am noticing the daily and weekly meetings only appear on the list once. Is there anyway to simply list what is shown on the calendar for a given period of time regardless of occurrence?
Was this answer helpful?
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 715
715 Satisfied Customers
Experience: Computer Software Support specialist for more that 10 years

Jess M. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

715 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

505 satisfied customers

Certified Software expert with over 10 years experience.

IT Miro

IT Miro

Computer Scientist

497 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Jins M. N.

Jins M. N.

Computer Hardware Engineer

463 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Kamil Anwar

Software Specialist

456 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

164 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I bought online and it let me change my account for game
I bought online and it let me change my account for game access but not for messages … read more
John T. F.
John T. F.
Self-employed Business Owner
Two Decades Field Experience
1,041 satisfied customers
I have a Windows 10, and I am trying to connect a pac dot
I have a Windows 10, and I am trying to connect a pac dot pen. When I go to the Windows Pen settings page, there is missing information … read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
789 satisfied customers
My computer auto updated and i lost everything. Asus x751l
it update last night and was asking me for a keyboard choice … read more
Harry
Harry
1,694 satisfied customers
This morning when I went to look at my Instagram it said
This morning when I went to look at my Instagram it said that I have been logged out of my Instagram. I did not log out. So I went to a help screen because I can't remember my password. They help supp… read more
Ebram Kerolos
Ebram Kerolos
Information Technology
22 satisfied customers
I'm a subscriber to Ancestry,com. When I sign on it gives me
I'm a subscriber to Ancestry,com. When I sign on it gives me my trees but with Family Search a the look-up program. I just want to get back to seeing leaves … read more
Harry
Harry
1,694 satisfied customers
I had to buy a new modem and now I can't get FaceTime. I
I had to buy a new modem and now I can't get FaceTime. I cannot uninstall the app. … read more
caraleneK
caraleneK
Service Manager
1,864 satisfied customers
I'm having a real problem with a PDF background page color
Hi...I'm having a real problem with a PDF background page color that changes from teal to blue during preflight. It is for a IngramSpark Printers (need PDF/X 1a). This is my second day trying to fix t… read more
Harry
Harry
1,694 satisfied customers
I can't ring this number via skype Australia 132307. Today.
I can't ring this number via skype Australia 132307 … read more
Harry
Harry
1,694 satisfied customers
Google sheets - What is the fastest way to select data from
Google sheets - What is the fastest way to select data from a large spreadsheet and create a different spreadsheet using only the selected data from the first spreadsheet?… read more
George Sibiya
George Sibiya
PhD
288 satisfied customers
Microsoft (Wimdows Update)has drastically altered my
Microsoft (Wimdows Update)has drastically altered my computer by apparently resetting my system without prior notice or warning to me whatsoever and in the process I have lost virtually all of stored … read more
hongkongpom
hongkongpom
Computer Desktop Support
Associate Degree
288 satisfied customers
How do I get a google play store app? I need it to access
how do I get a google play store app? I need it to access bitcoin. … read more
Mr.Med
Mr.Med
1,098 satisfied customers
I want to use pages to write something and put a photo from
I want to use pages to write something and put a photo from my desktop on the page. I then want to write the message around the photo. … read more
Harry
Harry
1,694 satisfied customers
I need to correct my account address information and am
Hi; I need to correct my account address information and am having trouble with the instructions. … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
875 satisfied customers
Covert to word scanned documents. I do not remember. I have
i have scanned documents in my EMAIL that i want to convert to word … read more
Mr.Med
Mr.Med
1,098 satisfied customers
Hard drive crashed and trying to reactivate my skype
hard drive crashed and trying to reactivate my skype account. forgot password ***** to reactivate microsoft is sending authority key to an email that has been closed … read more
Harry
Harry
1,694 satisfied customers
Every time I turn it on it's giving me CMOS checksum error.
Every time I turn it on it's giving me CMOS checksum error. When I try to do BIOS … read more
hongkongpom
hongkongpom
Computer Desktop Support
Associate Degree
288 satisfied customers
I downloaded adobe flash player on my MAC with OS 10.7.5. I
I downloaded adobe flash player on my MAC with OS 10.7.5. I pushed the install button and nothing seemed to happen. It did not appear as an application and it was downloaded into my download file. … read more
Sheri
Sheri
Bachelor\u0027s Degree
527 satisfied customers
My windows 10 crashed and had to be reloaded, losing all my
my windows 10 crashed and had to be reloaded, losing all my non microsoft apps. I re-downloaded thunderbird but it doesn't recognize any past passwords. I've gone thru all the online help to no avail.… read more
Harry
Harry
1,694 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x