Solved

Extracting Outlook appointment information for invoicing

Posted on 2016-09-17
3
66 Views
Last Modified: 2016-12-13
Hello,

I'm wondering if it is possible to pull calendar appointment data across five shared Exchange calendars (Office 365) that could be used to create invoices.

We have five providers who work with a range of clients; however, we have about 5-8 primary offerings with fixed prices.  So, as we enter appointments, it might look something like:

Client Name - Offering Type - Participant Name - Provider Name - Location

For the 5-8 offerings, it would be great if, when extracting the calendar data, the correct price would be linked up with the offering type (e.g., Offering 1 = $50, Offering 2 = $100, etc.).  

Does anyone know if this is possible and how I might go about doing it?

Thanks in advance for your help!

Nate
0
Comment
Question by:Nathan Whittier
3 Comments
 
LVL 94

Accepted Solution

by:
John Hurst earned 500 total points
ID: 41803440
You can export Calendar entries to .VCS or .ICS files.

I set up Invoices in QuickBooks and just copy calendar journals (what I did) and paste into QuickBooks Invoices. Works fine.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question