WORD/EXCEL Mailmerge

[Yendorian]

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

 

[Peter Jamieson]

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]

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