Attachments.Add Method

Publisher Developer Reference

Adds an Attachment object to the Attachments collection of a Microsoft Office Publisher publication.

Version Information
 Version Added:  Publisher 2007

Syntax

expression.Add(Filename)

expression   A variable that represents an Attachments colleciton.

Parameters

Name Required/Optional Data Type Description
Filename Required String File name of the attachment.

Return Value
Attachment

Example

The following Microsoft Visual Basic for Applications (VBA) macro shows how to add an attachment to the message in an e-mail merge. The code adds an attachment to an e-mail message and then prints the number of current attachments to the message in the Immediate window.

The attachment in this example is an image file at the root of the C drive. Before running the code, replace "C:\image.jpg" with the path to and name of the file on your computer that you want to add as an e-mail attachment.

Before you can create an e-mail merge, you must use the OpenDataSource method of the MailMerge object to connect the active document to a data source. To run the merge, use the Execute method of the MailMerge object. For an example of how to connect to a data source and create an e-mail merge, see the EmailMergeEnvelope object topic.

Visual Basic for Applications
  Public Sub Add_Example()
Dim pubAttachment As Publisher.Attachment

Set pubAttachment = ThisDocument.MailMerge.EmailMergeEnvelope.Attachemts.Add("<em>C:\image.jpg</em>")
Debug.Print ThisDocument.MailMerge.EmailMergeEnvelope.Attachemts.Count

End Sub

See Also