Home » Deeper in to NetSuite » How To Export NetSuite Contacts to Microsoft Outlook

How To Export NetSuite Contacts to Microsoft Outlook

Although NetSuite supports integration with MS Outlook, it is a complex process which requires considerable knowledge of NetSuite in order to achieve. So, what do you do if you don’t have this integration in place and want to export your NetSuite contacts to MS Outlook? Read on to find out.

As you may know, NetSuite offers a lot of room for customization (using Suite Builder and SuiteScript) via which you can implement and enable pretty much any functionality you need in addition to all the robust system functionalities offered by NetSuite. The same is the case here, since you can easily export NetSuite contacts to Outlook via SuiteScript. Here’s how you can do that.

CTA - NetSuite Homepage Banner

Steps for Exporting NetSuite contacts to MS Outlook?

First let’s look at how to export NetSuite contacts. Just follow the steps below for that.

  • Create a Suitelet
  • Get the values from your required field(s).
  • Create a file from the information gathered in step b
  • The file should be created in plaintext format with .vcf format
  • Add a button on the contact record that will call this Suitelet (as shown below).
export outlook contacts to netsuite

Be sure to strictly follow Outlook’s Vcard format (depicted below) when creating your contact file (for export). If you don’t, some or all of the contact data may not be imported to Outlook.

export outlook contacts to netsuite
export outlook contacts to netsuite
CTA - NetSuite Integration Connector Banner

VCard 4.0 Format

BEGIN:VCARD
VERSION:4.0
N:Harold;Gross;;Mr.;
FN:Harol Gross
ORG:CreateYourCruise
TITLE
TEL;TYPE=work,voice;VALUE=uri:tel:+1-855-978-5292
EMAIL:[email protected]
END:VCARD

The rest of the process is quite straight forward. Just open the exported file in Outlook, and if all steps have been followed correctly, then Outlook will show all the fields exported which will be filled in with the correct values for the exported NetSuite contact. All you need to do after that is just hit ‘Save’ to save the exported contact as an Outlook contact.

CTA - NetSuite Magento Connector Banner

Wrapping Up

As you can see, NetSuite customization makes it easy to implement features which otherwise, will be costly to implement or find workarounds for. The trick is use NetSuite’s existing functionality as much as possible to support your requirement. In this case for example, a simple text file exported with a different extension did the job. Hope you found this post useful. If you have any questions or suggestions, feel free to leave a comment below.

To learn more about how to get the most out of your NetSuite investment, contact us for a free consultation.

Get In Touch With Our Experts


    Get In Touch With Our Experts

      I have read and agree to the Privacy Policy of Folio3
      I agree to be contacted by Phone or Email by Folio3

      Get in touch with the

      Award-Winning

      End-to-end NetSuite Servicing Agency

      Tell us how may we assist you!