Import contacts from Office 365

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. 
    Active Syncs
  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.

    • Related Articles

    • Sync leads from Office 365

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

      Install the Zoho CRM app for Microsoft Office 365 to seamlessly synchronize data between the two applications. Currently, this integration allows for user import, calendar synchronization and contacts synchronization. Install Zoho CRM app for Office ...
    • Office 365 Sync for Zoho Recruit

      Install the Zoho Recruit app for Microsoft Office 365 to seamlessly synchronize data between the two applications. This integration currently allows Calendar and Contacts synchronization. To enable Office 365 calendar synchronization in Zoho Recruit  ...
    • How do I deny access to a Office 365 account?

      If you deny/change Office 365 integration: You cant import your Office 365 contacts into Zoho Campaigns any further. Events will not be created in your Office 365 calendar when a campaign is scheduled or sent. Denying access to Office 365 1. From ...
    • Import contacts from Zoho Contacts

      You can set up sync between Zoho Contacts and Zoho Campaigns to import all your contacts from Zoho Contacts account into a mailing list of your Campaigns account. Set up a sync From the Navigation bar, select the Contacts module. Select Sync ...