My user requested to use cc fields in his mail merge, so I refereed to the solution by GrahamSkan(2011-08-14) and tried to run it.
After having issues, I started to debug, and realized that I am not really accessing the recipients' list in mail merge.
Here is what I did.
1. Run the mail merge to create the list, save and close it. I saved the merged documents as Test.docx, verified that it has 3 sections.
2. Created a module containing the code from GrahamSkan's post. Compiled.
3. Ran the code. It does not send.
If I strip the Table portion of the code and hard code in the recipients names, the code will work and it will send out 3 emails.
When I debug, the variable "DataRange" is set to Nothing. That is why I think I am not accessing the recipients list.
Am I saving the merged documents in the wrong format? I do not think I have a clear understanding of how the recipients are stored in "ActiveDocument.Table" object.