mail merge help

[angler2229]

We are creating mail merge documents with Excel and Word. I have created the data source in Excel and then opened a Word document and followed the steps to merge the two files. The problem is that the Insert Merge Fields button says Auto Merge Fields instead. When I look at the list, it shows Auto Merge Field 1, etc.

I have retraced my steps several times, to no avail. I did get it to work one time.

My data source file is dedicated just to the data I want to merge and has no more than one worksheet.

Any ideas? The Office Assistant is no help at all.

Thanks,

angler

 

[ytlew]

Do you named your data with title?

 

[xlhelp]

To add to what ytlew mentioned:

You either don't have any Labels in your Excel or you are selecting a range that doesn't include column labels.

Indu

 

[nberryman]

OK problem sorted

Open Excel make sure you have labels at the top of each column and no blank rows then select the data. Click Insert Name and give the data a name and save

Open the Word document and Click Tools Mail Merge. Click the data button and open data source.

Select the file and click Open

Select the named range off the list (not Entire Spreadsheet)

This should cure it

Any problems let me know

Neil