MailAsAttachment Property

Microsoft Word Visual Basic

MailAsAttachment Property

       

True if the merge documents are sent as attachments when the mail merge destination is an e-mail message or a fax. Read/write Boolean.

expression.MailAsAttachment

expression   Required. An expression that returns a MailMerge object.

Example

This example performs a mail merge operation and sends the merge results as attachments to e-mail messages. The e-mail addresses are stored in the MailAddress merge field.

With Documents("Main.doc").MailMerge
    .MailAsAttachment = True
    .Destination = wdSendToEmail
    .MailSubject = "Special offer"
    .MailAddressFieldName = "MailAddress"
    .Execute
End With