Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
WORD/EXCEL Mailmerge
I have databases on two sheets of an EXCEL file and am trying to merge the
details from the second sheet into a WORD doc. Whenever I try this, I only get the column headings of the first sheet. How can I force it to give me the headings from Sheet 2 only? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
WORD/EXCEL Mailmerge
Which version of Word are you using?
If it is Word 97 or 2000, check the "Select Method" box in the "Open Dtaa Source" dialog box, then select your file and proceed. You should see an additional dialog box in which you can select the ODBC method to connect to the file. Then, when you see a Select Table dialog, try to ensure that the file you selected is the name displayed next to "Workbook", then click the options button and check all the boxes. You should see all the worksheets and named ranges listed. If it's Word 2002 or 2003, something is probably going wrong unless you are already explicitly selecting the old DDE method to connect, because Word should let you select any sheet using any of the other methods. But to do the same in Word 2002/2003, check Word Tools|Options|General|Confirm conversions at open, then go through the connection process again and try either OLE DB or ODBC. For further info on these methods, see http://tips.pjmsn.me.uk/t0003b.htm Peter Jamieson "Yendorian" wrote in message ... I have databases on two sheets of an EXCEL file and am trying to merge the details from the second sheet into a WORD doc. Whenever I try this, I only get the column headings of the first sheet. How can I force it to give me the headings from Sheet 2 only? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
WORD/EXCEL Mailmerge
Hi Peter,
Thanks for the rapid response. I am using OFFICE Pro 2003. By un=sing the ODBC setting I was able to get the option to choose my Sheet. Problem solved!!! Thanks again Yendorian "Peter Jamieson" wrote: Which version of Word are you using? If it is Word 97 or 2000, check the "Select Method" box in the "Open Dtaa Source" dialog box, then select your file and proceed. You should see an additional dialog box in which you can select the ODBC method to connect to the file. Then, when you see a Select Table dialog, try to ensure that the file you selected is the name displayed next to "Workbook", then click the options button and check all the boxes. You should see all the worksheets and named ranges listed. If it's Word 2002 or 2003, something is probably going wrong unless you are already explicitly selecting the old DDE method to connect, because Word should let you select any sheet using any of the other methods. But to do the same in Word 2002/2003, check Word Tools|Options|General|Confirm conversions at open, then go through the connection process again and try either OLE DB or ODBC. For further info on these methods, see http://tips.pjmsn.me.uk/t0003b.htm Peter Jamieson "Yendorian" wrote in message ... I have databases on two sheets of an EXCEL file and am trying to merge the details from the second sheet into a WORD doc. Whenever I try this, I only get the column headings of the first sheet. How can I force it to give me the headings from Sheet 2 only? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DDE mailmerge between Word and Excel | Microsoft Word Help | |||
excel--to-excel linked cells not updated in word mailmerge | Mailmerge | |||
mailmerge using Word/Excel 500.00 in Excel shows as 500 nt 500.00 | Mailmerge | |||
Word/Excel Mailmerge | Mailmerge | |||
mailmerge from excel into word | Mailmerge |