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.
expression An expression that returns a 'MailMerge' object.
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
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.