Import contacts from Office365 - Online Help | Zoho Campaigns

Import contacts from Office 365

Zoho Campaigns enable you to import contacts from Office 365. All you have to do is integrate your Zoho Campaigns account with Office 365 and create a sync. Then contacts in your Office 365 account can be automatically imported as contacts into your Zoho Campaigns account.

Create Sync

  1. From the Navigation toolbar, select Contacts and click on Sync Services
    sync services menu
  2. Click on New Sync under Office 365. 
  3. Enter following details,
    • Sync Name- This is for internal reference.
    • Sync To Sync to Mailing List- Choose the mailing list into which you want to import the contacts.
  4. Click Next
    sync details

Map fields

You can map your Office 365 fields to Zoho Campaigns fields in this section. Basic details such as email address, first name, and last name are pre-mapped. Mapping the email address field is mandatory. You can map additional fields by clicking on Map more link. Once done, click Save and Continue.

For instance, you can map the email address field in Office 365 against the Contact email field in Zoho Campaigns.
Email Address (Office 365) = Contact Email (Zoho Campaigns)
First Name (Office 365) = First Name (Zoho Campaigns)

map fields

How can I map additional fields in Office 365 sync?

You can map additional fields by clicking the Map more link. For example, you can map the Birthday field in Office 365 to a custom field in Zoho Campaigns.
Birthday (Office 365) = Birthday (Zoho Campaigns custom field)*
*To add a new custom field in Zoho Campaigns while mapping fields, click the New Fields option.

Sync Detail View

  1. From the Navigation toolbar, select Contacts and click on Sync Services.
  2. Click on Active Syncs under Office365. 

  3. Hover over the sync and click View Details.
    view details

You can view sync details like mapped list, and last retrieval time; contact details like the number of newly added, re-added, duplicate and deleted contacts. The sync remains active till the completion of contact import.

Edit Field mapping

You can re-map or map more fields for your sync settings by choosing the Edit Mapping in the Edit drop down.

Import Details/History

Use this option to get a detailed history of the contacts synced from Office365 to Zoho Campaigns. You can see this in the detailed view of the sync.

Status
Description
Total Contacts
Contacts imported/synced in a single fetch.
New Contacts
Contacts added to the Campaigns organization.
Re-added Contacts
Contacts already deleted in Campaigns account but now added again.
Duplicate Contacts
Contacts already present in Campaigns account.
Ignored Contacts
Contacts are not added to the mailing list.
Deleted Contacts
Contacts deleted in Books account and getting updated in Campaigns as well.

Ignored Contacts

Contacts are ignored during the import if they fall under one of the following categories,

Status
Description
Bounced
Contacts bounced from the recipient's inbox, or email addresses do not exist.
Do-Not-Mail
Contacts added to the Campaigns organization.
Group Email(s)
Contacts having a role/group email address. For e.g. info@, administrator@, careers@, service@, support@, etc.
File Duplicate(s)
Contacts present more than once in the file.
Invalid Pattern
Contacts with an invalid pattern; e.g. patriciazylker.com, john@gnail.com
Empty email address
Contacts whose email address field is missing.

      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit

                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsFormstack alternativeEncrypted Forms

                              Wufoo alternativeSecure Forms

                              TypeformWCAG

                                All-in-one knowledge management and training platform for your employees and customers.

                                          Create. Review. Publish.

                                          Write, edit, collaborate on, and publish documents to different content management platforms.

                                          Get Started Now




                                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                Manage your brands on social media


                                                                  • Desk Community Learning Series


                                                                  • Digest


                                                                  • Functions


                                                                  • Meetups


                                                                  • Kbase


                                                                  • Resources


                                                                  • Glossary


                                                                  • Desk Marketplace


                                                                  • MVP Corner


                                                                  • Word of the Day


                                                                  • Ask the Experts


                                                                    Zoho Sheet Resources

                                                                     

                                                                        Zoho Forms Resources


                                                                          Secure your business
                                                                          communication with Zoho Mail


                                                                          Mail on the move with
                                                                          Zoho Mail mobile application

                                                                            Stay on top of your schedule
                                                                            at all times


                                                                            Carry your calendar with you
                                                                            Anytime, anywhere




                                                                                  Zoho Sign Resources

                                                                                    Sign, Paperless!

                                                                                    Sign and send business documents on the go!

                                                                                    Get Started Now




                                                                                            Zoho TeamInbox Resources





                                                                                                      Zoho DataPrep Demo

                                                                                                      Get a personalized demo or POC

                                                                                                      REGISTER NOW


                                                                                                        Design. Discuss. Deliver.

                                                                                                        Create visually engaging stories with Zoho Show.

                                                                                                        Get Started Now








                                                                                                                            • Related Articles

                                                                                                                            • Office 365 integration

                                                                                                                              1. How do I deny access to an Office 365 account? Follow these steps to deny access to the Office 365 integration with Zoho Campaigns: Click the Settings icon in the top-right corner. Choose Apps under Integration. Hover over Office 365 and click ...
                                                                                                                            • Import contacts from Office 365 - New Version

                                                                                                                              Zoho Campaigns enable you to import contacts from Office 365. All you have to do is integrate your Zoho Campaigns account with Office 365 and create a sync. Then contacts in your Office 365 account can be automatically imported as contacts into your ...
                                                                                                                            • Integrate with Zoho CRM

                                                                                                                              New CRM integration model 1. Will editing the sync configuration affect the existing synced data? Editing the sync configuration mainly affects how future syncs are handled. The data that is already synced in Zoho Campaigns and Zoho CRM will remain ...
                                                                                                                            • Import Contacts from Zoho WorkDrive - New Version

                                                                                                                              Zoho Campaigns lets you import contacts from different cloud storage services. You can import contacts stored in Zoho WorkDrive as contacts in Zoho Campaigns. The file to be imported should meet the following requirements, It should be in either ...
                                                                                                                            • Import Contacts from Dropbox

                                                                                                                              We have recently updated Topics in Zoho Campaigns. Please click here for the updated help document. Zoho Campaigns lets you to import contacts from different cloud storage services. You can import contacts stored in Dropbox as contacts in Zoho ...
                                                                                                                              Wherever you are is as good as
                                                                                                                              your workplace

                                                                                                                                Resources

                                                                                                                                Videos

                                                                                                                                Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                eBooks

                                                                                                                                Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                Webinars

                                                                                                                                Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                CRM Tips

                                                                                                                                Make the most of Zoho CRM with these useful tips.



                                                                                                                                  Zoho Show Resources