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. 

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

    • Import contacts from Zoho Invoice

      We have recently updated Topics in Zoho Campaigns. Please click here for the updated help document. Zoho Campaigns integrates with Zoho Invoice to help you build your mailing lists. You can map custom fields in Zoho Invoice to Zoho Campaigns to ...