ATTACHMENTS

This function returns a list of attachments and their properties, in XML format. You search for attachments that have a particular property value. These are the supported properties:

  • Address
  • FileName
  • AddedDate
  • Author
  • AdditionalInformation
  • References

Syntax

=ATTACHMENTS("property","pattern")

You can use the * wildcard character in the search pattern.

Examples

This example searches for and returns all attachments that have a filename ending in .jpg:

=ATTACHMENTS("FileName","*.jpg)

Dates are returned in the format in which they are stored. To search on the AddedDate property, insert the required date in a cell and refer to the cell. In this example, the date is specified in cell B17:

=ATTACHMENTS("AddedDate","B17&"*")