I have been trying the code from https://www.msofficeforums.com/mail-...documents.html in my MailMerge and, when I would run it, the computer would do nothing. I asked ChatGPT why that might be. I gave me some new code to add, including a record counter and a message box that would activate if my mail merge found no records in my source document. Sure enough, when I ran that code I got the "no records" message. But when I run the mail merge manually, everything works fine with no issues. When I record a simple macro to print one record everything works fine with no issues. My data source is a table in another word document, it is not an excel file or anything else.



What could be going on?

ChatGPT often produces garbage code, which is why many organizations, forums, etc. ban its use.

Do you get the mailmerge SQL prompt when you open your mailmerge main document?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes, I do get the SQL prompt. I have tried to run the mail merge code with both the data source file open and closed.

Are you sure your mailmerge main document is the active one when you run the macro?

What happens if you insert:
Msgbox "Records: " & .MailMerge.DataSource.RecordCount
after:
With ActiveDocument

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Macropod, sorry I just saw this response. I tried something different today. I copied my source data from a table in Word doc to an Excel spreadsheet and macro worked perfectly!

Glad you got it sorted.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]