#Export outlook contacts to csv 2013 how to
#Export outlook contacts to csv 2013 code

Import to an iClanedar (.ics) or vCalendar file (.vcs).You will notice that there are other export options listed during this process, such as: cvs files from Outlook exports can get a bit difficult to navigate the larger they are, particularly when you export a folder containing email messages. The same goes if you want to export some of your email messages.

#Export outlook contacts to csv 2013 how to

More Information on How to Export Contacts from Outlook 2013ДЄ similar method can be used to export other items from your Outlook file as well.ДЇor example, if you have a calendar in Outlook and would like to view it as a spreadsheet, then you can select to export the calendar portion during this process instead.

From the merged document, you can now copy and paste your table in Excel.Once the export is complete you can open the file to view its contents.ДЇor more information on working with exported contacts in Outlook 2013 continue reading the section below. Word will open your document, but it won't be merged. Browse for the word document you created (in my case 'merge shared outlook contacts with this file').ДЎ3. Under 'document file', select existing document. On the home tab in Outlook, select mail mergeДЎ2. Go to the shared contacts and select the contacts you want to merge.ДЎ1. I named mine 'merge shared outlook contacts with this file'.ДЎ0. After you have row 2 completed, copy and past row 2 information down the entire page.Д©. 'Next Record' is only used in the first cell of each row.ДЁ. RowДў, column 2 (and all other columns in this row) will only have a 'merge field'. In the same column (row 2, column 1) insert your first 'merge field' you want next to the 'next record' field. After you have each 'insert merge field' placed in their own cell in row 1, use the 'next record' field in row 2, column one. 'Insert merge field' items placing each item in their separate column in the table created.Д§. Select the 'dummy' Excel mail merge document to use the column headers.Д¦. You want your table to consume the entire page (not just a few lines)ДҐ. Insert a table with the same number of columns you need to export from Outlook. In Word, create a mail merge document using the 'normal word document' mail merge optionД¤. Save the 'dummy' Excel mail merge document.ДЈ. I did not include any data in the columns under the headers.Дў. I wanted to use 6 columns from the Outlook contacts and named 6 columns in Excel exactly how they are labeled in Outlook. I created a 'dummy' mail merge source document in Excel. My level of permissions on the shared contacts is 'publishing editor'ДЎ. Even though it's a lengthy process, you can save your Word main merge document and use it in the future for exporting shared contacts without recreating the entire process. It's a little bit of a process,Д«ut I was able to accomplish it. Below are the steps I followed to accomplish the process. I know I'm pretty late with responding to this, but wanted to post how I did it if someone else is searching for a way to export shared contacts to Excel. Set oLo = (xlSrcRange, Cells(1, 1).CurrentRegion,, xlYes) If > 0 Then ActiveSheet.ListObjects(1).DeleteДЄrray('Name', 'Company', 'Address', 'City', 'State', 'Zip', 'Phone', 'Email') Set olFolder = olA.GetNamespace('MAPI').GetSharedDefaultFolder(olRecipient, olFolderContacts)

Set olRecipient = olNS.CreateRecipient(sAccountName) GetContacts('Craig Hatmaker') Sub GetContacts(sAccountName As String)Дim olNS As Namespace '(v=office.12).aspxДim olRecipient As Recipient '(v=office.12).aspxДim olFolder As MAPIFolder '(v=office.12).aspx

The following example, when run from the VBE's immediate window in Excel will retrieve all contacts from the account

#Export outlook contacts to csv 2013 code

For those okay with VBA, this code pulls contacts from an OutlookВ shared folder (or the personal folder) into an Excel Table.