I snagged the following macro from an Internet source and have it in my Word document for mail merge:
Private Sub Document_Open()
Public Sub DoMailMerge()
DocName = ActiveDocument.Name
.Destination = wdSendToNewDocument
'Close mailmerge document
I had this working not long ago, but putting it in a new merge doc generates the error "Requested object is not available" as shown in the attached image. Apparently, I just got lucky with how I inserted the macro before because I cannot duplicate the working state.
What am I doing wrong?