Software

Ask something
Discussion Locked

Mail Merge using Excel,Multiple Workbook

0 helpful
6 replies

by stargater

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an excel spreadsheet with 3 workbooks - all of them contain names and addresses. The headings are on the first workbook. I go into Word and use the mail merge facilty - mailing labels and open the excel spreadsheet as the data source. I get asked if it is the Entire SpreadSheet and I click OK. But it will only pull in the details on the first workbook. How do I get it to pull in the details from the second and third workbook. I could take each workbook and create a separate spreadsheet but I don't want to have to do this.

thanks.

6 replies

by dklippert

Use Named ranges. Select your data and go to Insert>Name Define.
Or select your data. Enter your name in the "Name" box on the Formatting toolbar and hit Enter.

by stargater

I tried defining a name which covered the 3 workbooks but when I put this name instead of "Entire Spreadsheet" it still only pulls in the first work book.

Am I doing something wrong - have tried it on Office 97 and Office 2000.

by kspugh

It is my understanding & previous experience that merge will only work with the first spreadsheet in a workbook. (I have not tried the named range as previously suggested. That sounds promising.)

This discussion is closed to new replies.