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. 
    Sync with Office365
  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.

    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





                        Still can't find what you're looking for?

                        Write to us:  support@zohoforms.com


                              




                            


                          New to Zoho Social?

                              Zoho Marketing Automation

                                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 SalesIQ Resources



                                                        Zoho TeamInbox Resources



                                                                Zoho DataPrep 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

                                                                                            • 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 ...
                                                                                            • Import Contacts from Evernote

                                                                                              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 Evernote as contacts in Zoho ...
                                                                                            • Import contacts from Shopify

                                                                                              Disclaimer: This is the help page for users who have already associated their Shopify store and want to import contacts and send email campaigns. If you’re looking the help page for ecommerce solutions for Shopify, click here. Zoho Campaigns enable ...
                                                                                            • Import Contacts from Box

                                                                                              Zoho Campaigns lets you import contacts from different cloud storage services. You can import contacts stored in Box as contacts in Zoho Campaigns. The file to be imported should meet the following requirements, It should be in either Excel or CSV ...
                                                                                            • Import contacts from Google Drive

                                                                                              Zoho Campaigns lets you to import contacts from different cloud storage services. You can import contacts stored in Google Drive as contacts in Zoho Campaigns. The file to be imported should meet the following requirements, It should be in either ...
                                                                                            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