| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mail Merge
Is it possible to specify which worksheet on an excel spreadsheet that Microsoft word picks up the data from. I seem to only be able to make Word find data records on the first worksheet and I could do with mailmerging the data on the third. I need the first worksheet's data for a separate merge so I can't simply swap sheet 3 for sheet 1! Many thanks for any help with this... CF -- clown fish ------------------------------------------------------------------------ clown fish's Profile: http://www.excelforum.com/member.php...o&userid=31364 View this thread: http://www.excelforum.com/showthread...hreadid=510582 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mail Merge
Select the worksheet columns and Insert--Name--Define. When you go to
merge, the name will be one of the options along with Entire Spreadsheet... ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "clown fish" wrote in message ... Is it possible to specify which worksheet on an excel spreadsheet that Microsoft word picks up the data from. I seem to only be able to make Word find data records on the first worksheet and I could do with mailmerging the data on the third. I need the first worksheet's data for a separate merge so I can't simply swap sheet 3 for sheet 1! Many thanks for any help with this... CF -- clown fish ------------------------------------------------------------------------ clown fish's Profile: http://www.excelforum.com/member.php...o&userid=31364 View this thread: http://www.excelforum.com/showthread...hreadid=510582 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficult for me, probably basic to you | Excel Worksheet Functions | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| Serious Mail Merge Problem | Excel Discussion (Misc queries) | |||
| Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Hybrid Mode
