Mail merge from Excel data to Word template

**lmiguel13** · 07-09-2013, 05:05 PM

Dear ExcelForum Friends,

I am trying (and failing) to set up a mail merge with a Word document. I would like for the doc to take information entered in specific columns and display it in the right field. I've set up the field and the excel doc and went through the mail merge wizard's steps for setting it up but it doesn't seem to be doing what I want. I think I need to add something to the spreadsheet that ensures the doc takes the right information. Please help. I am attaching the doc and spreadsheet below.

Thanks,
MichaelFields TEST.Contract Entries.xlsx Fields Test.Contract to Provide Legal Services.docx

**Crawfinator1** · 07-09-2013, 10:10 PM

You need header fields in your spreadsheet - Once they are in you should be good

**lmiguel13** · 07-10-2013, 10:11 AM

I'm still not getting it. I must be using the wrong field name. I want the field to take the data from the right place in the excel file and insert it into the correct place in the word file. How can I do that?