Hello, everyone!
I've been working on replicating the tutorial located at
https://www.msofficeforums.com/mail-...-tutorial.html to automate a mail merge process.
I've run into some issues during my attempts. Specifically, I've encountered the following error messages: "No value given for one or more required parameters" and "Word was unable to open the data source. A field calculation error occurred in record 1." For my practice, I've been using files named State_City.xlsx and Test_dir.docx.
Let me provide some background information about my project. I have an Excel sheet with multiple rows, where the primary column is labeled "Document Name." Additionally, there are columns labeled ABCDE, each containing different values. In some cases, for the same "Document Name," there may be varying values in the ABCDE cells. To replicate my data, I've used a file called 01_Test_Excel.xls.
My objective is to generate a mail merge document for each unique "Document Name." Each document should contain a table with headers for the ABCDE cells, and all rows with the same "Document Name" should be consolidated into one document. Each document with a unique "Document Name" should then be saved separately.
While attempting this process, I followed the tutorial mentioned earlier, but I consistently encountered errors during the mail merge execution, as previously mentioned.
I'm reaching out to request assistance from anyone who may be able to help me create a mail merge document for the scenario I've described. Your guidance and expertise would be greatly appreciated! Thanks and looking forward for replies