MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using Excel as Mail Merge

Posted by Jennifer B. on May 23, 2001 7:16 AM

I have a workbook set up with several pages of data.

I need to do a merge mail, not utilizing the entire workbook but just an individual page of the workbook.

Is this possible?

Posted by lenze on May 23, 2001 9:02 AM

Yes: When you choose open data source from the Mail Merge dialog in Word and select your Excel file, it will prompt you for which sheet(s) you wish to use. Also, you can do more filtering prior to merging the list.

Posted by Barrie Davidson on May 23, 2001 9:03 AM

Name the range you want to use for the mail merge and then reference that in your Word document.

Note, when I tested this, the spreadsheet had to be saved with the first sheet in the workbook containing the range you want to use in the mail merge.