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

    • 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 ...

    • Import Contacts from Google Contacts

      Zoho Campaigns enable you to import contacts from Google Contacts. Google Contacts is nothing but the contacts you have in your Gmail account. All you have to do is integrate your Zoho Campaigns account with Google and create sync. Then contacts in ...

    • 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 ...

    • 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 Evernote

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