View Single Post
 
Old 10-13-2024, 05:23 AM
rockstar1989 rockstar1989 is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2024
Posts: 4
rockstar1989 is on a distinguished road
Default Generating Letters from Excel List

Hello,

I need help in creating a grouping mail-merge for generating letters from Excel list.

Please check the example sheet attached. I need to generate letters for each company in column C. The column C is the primary key. The number of rows for each company will vary.

The format of letters (word document) is attached as "Example Output" and the column references is also attached. From the example sheet, 3 letters will be generated and saved to a folder.

I don't want to use the add-in. I tried to setup the mail-merge using the instructions in this thread but I was not able to generate accurate results, may be I am doing something wrong https://www.msofficeforums.com/mail-...-tutorial.html

Could anyone please help setting up the mail-merge.

Thanks in advance for your support.
Attached Images
File Type: jpg Column Reference.JPG (42.6 KB, 8 views)
Attached Files
File Type: xlsx Example Sheet.xlsx (9.4 KB, 3 views)
File Type: docx Example Output.docx (17.5 KB, 3 views)
Reply With Quote