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
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.