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

Attached Files

	State_City.xlsx (13.0 KB, 3 views)
	Test_dir.docx (15.7 KB, 3 views)
	01_Test_Excel.xls (8.3 KB, 3 views)

See Merge Many To One

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Hello GMayor,

I would like to express my gratitude for your prompt response to my inquiry and for the valuable suggestions you've provided. I have carefully reviewed the recommendations mentioned in your previous message, which appear to center around the use of a specific add-on to achieve the desired task. Unfortunately, I am not permitted to download and utilize this particular add-on for my application. Therefore, I am in search of a VBA macro code solution for my task. I would greatly appreciate any guidance or suggestions you can offer in this regard.