IP.CONTACTACCADDRESS function

Description

Returns the contact account address.

Syntax

=IP.CONTACTACCADDRESS(ContactAccountCode,AddressColumnName,AddressType)

Attribute	R/O	Description
ContactAccountCode	(required)	Contact code
AddressColumnName	(required)	Contact address field
AddressType	(optional)	Address type code

• Address Column Name options:

  • Address
  • City
  • Region
  • Postcode
  • Country

• Address Type code examples:

  

  See Address Types for full list.

Example:

=IP.CONTACTACCADDRESS(2000442,"Address","R")

Note

To return the full address to one Excel cell, use the Excel =CONCATENATE function, where each address element is separated by ", ".

e.g.

=CONCATENATE(IP.CONTACTACCADDRESS(2000442,"Address","R"),", ",IP.CONTACTACCADDRESS(2000442,"City","R"),", ",IP.CONTACTACCADDRESS(2000442,"Postcode","R"))

Returns, for example, 4 Parklands, Bolton, BL6 4SD.

---

Updated May 2025