mail merge using excel data source problem

pipermc · Apr 23rd, 2002, 06:00 PM

Hi there guru's =)

I have a little problem for you.. I have a series of Word documents that i need to use often. I have an Excel workbook that has different groups set up on their own worksheets ie per location. This i was hoping to use for the data source. The only problem is when i go to insert the merge fields it will only show the first worksheet.. Which in this case is just a summary sheet. The only way i can get the data is to move the group i want into the first sheet place. As my groups grow this will get rather messy.. Can anyone suggest a better way of doing it?

any help would be wonderful!

jmuscat · Apr 23rd, 2002, 11:49 PM

When you select open data source, in the select source popup window, place a check mark in the Select Method checkbox, positioned to the right of the file name field. This will then allow you to choose which worksheet you want to use.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 06:00 PM	#1
pipermc New Member Join Date: Apr 2002 Location: Australia Posts: 2	Hi there guru's =) I have a little problem for you.. I have a series of Word documents that i need to use often. I have an Excel workbook that has different groups set up on their own worksheets ie per location. This i was hoping to use for the data source. The only problem is when i go to insert the merge fields it will only show the first worksheet.. Which in this case is just a summary sheet. The only way i can get the data is to move the group i want into the first sheet place. As my groups grow this will get rather messy.. Can anyone suggest a better way of doing it? any help would be wonderful!

Apr 23rd, 2002, 11:49 PM	#2
jmuscat New Member Join Date: Apr 2002 Location: Sydney Australia Posts: 18	When you select open data source, in the select source popup window, place a check mark in the Select Method checkbox, positioned to the right of the file name field. This will then allow you to choose which worksheet you want to use.