![how to export office 365 contacts to excel how to export office 365 contacts to excel](https://cdn.extendoffice.com/images/stories/doc-outlook/export-email-in-date-range/kutools-bulk-save-2.png)
If you do not see it in your list of actions, simply copy the code below. Next, use a Create File action, name the file as per your requirement and for the file content use the expression: base64ToBinary(outputs('ExcelDoc'))įinally, create add a new action by searching for HTTP and you should see this action:Īt the time of writing this post, this is a preview action and it is not available in all Office 365 Tenants. Within OL, File>Open & Export>Import/Export>Export to a File>Next>Comma Seperated.>Next. From the ribbon bar, click File -> Options From the left panel, choose Advanced, look for the Export session. A new feature has been introduced which should allow this but its not currently working for me (or anyone else I have heard from). (But maybe thats already possible, I just learned about Bookings today). The Import and Export Wizard opens in a new window. Additionally, the ability to import data (staff, customers, addresses etc) from Excel would be awesome. Select export format> Microsoft Outlook CSV. Select the Manage drop down tab and Export contacts. In the Import and Export Wizard, please click to select Export to a file option, and click the Next button. Click File > Open & Export > Import/Export (or File > Open > Import ).
![how to export office 365 contacts to excel how to export office 365 contacts to excel](http://magwebsitefiles2015.blob.core.windows.net/blogfiles/satyvirjasra/a88abb39-832a-431b-9750-861b2c2b3aee-Open-Live-Writer/How-to-Customise-Excel-Reports-Using-Mac_DB16/image_2.png)
For exporting contacts by category as a PST file in Outlook, please do as follows: 1. Next step is to create your Excel file and populate it with the data from your Select action:įirst, create a Compose action called ExcelDoc and paste in the Base64 representation of your template file. To start the process, open Microsoft Office Outlook, click File, select Open & Export in the left pane of the window, and hit Import/Export. You will see a list of your contacts, including: name, email address, etc. Export Outlook contacts by category to PST file.
![how to export office 365 contacts to excel how to export office 365 contacts to excel](https://d33wubrfki0l68.cloudfront.net/7e4c5968edc0ca5859d7c3721d29b656b413313b/3fdf2/wp-content/uploads/2018/07/image-5-2.png)
You can switch to Text mode by clicking on this:Ĭreate the Excel File and Populate with your Data Your Select action may look a different to mine, because the default mode is Key/Value mode.