MailMerge.MailAddressFieldName property (Word)

Returns or sets the name of the field that contains email addresses that are used when the mail merge destination is electronic mail. Read/write String.

Syntax

expression. MailAddressFieldName

expression An expression that returns a 'MailMerge' object.

Example

This example merges the document named "FormLetter.doc" with its attached data document and sends the results to the email addresses stored in the Email merge field.

With Documents("FormLetter.doc").MailMerge 
 .MailAddressFieldName = "Email" 
 .MailSubject = "Amazing offer" 
 .Destination = wdSendToEmail 
 .Execute 
End With

See also

MailMerge Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.