This is crazy but my code was working... few things I planned on fixing later but ever since adding the execute mail merge code and receiving my initial error, I keep receiving error: "run-time error '-2147023170 (800706be)': automation error the remote procedure call failed" even when the code is out.

Any idea? Thanks.