Ok, found the proper way to do this.
VB Code:
Dim oDoc As Word.Document Set oDoc = ActiveDocument With oDoc.MailMerge.DataSource .FirstRecord = 1 .LastRecord = .RecordCount End With With oDoc.MailMerge 'If OptPrinter.Value = True Then '.Destination = wdSendToNewDocument 'wdSendToNewDocument;wdSendToPrinter; wdSendToFax; wdSendToEmail 'ElseIf optFax.Value = True Then '.Destination = wdSendToFax 'ElseIf optEmail.Value = True Then .Destination = wdSendToEmail .MailSubject = "RobDog888 VB/Word Guru™" .MailAddressFieldName = "FieldThatContainsTheEmailAddresses" .MailAsAttachment = False .MailFormat = wdMailFormatHTML .Execute 'End If End With





Reply With Quote