I was trying to export PDFs individually by VBA. When I tried to run the code, it ket showing:
Run-time error '2501': The OutputTo action was canceled.

The first time I run the code, I successfully exported hundreds of PDFs. I do not know why it did not work the second time. I did do some updates to the query, but it should not affect the VBA.

If anyone knows how to solve this issue, please let me know. Thank you!