Word mailmerge

[Tracy at Axis]

We have an existing Excel spreadsheet with multiple spreadsheets, the data is
also used as mail merge data with Word. This worked perfectly in Office
2002, as we could choose which worksheet to use. Updated recently to Office
2003 and cannot get this to work, only get the option to choose Entire
spreadsheet, but not the individual worksheets as before. Please help -
thanks

 

[Doug Robbins - Word MVP]

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. After
doing that, when you attach the data source to the Mail Merge main document,
you will get a dialog box asking for the method by which the connection
should be made. Try the DDE option.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Tracy at Axis]

Thanks for the reply, but am already doing this. The data from the 1st
worksheet is all displayed correctly, the problem is that I cannot choose to
use different worksheets each time I either open the word document, or open
new data source. As you suggested I am choosing DDE option, in 2002 the
next dialogue box showed a list of worksheets where we could choose which one
we wanted the data from. In 2003 version only displays 'entire
spreadsheet'. I have tried defining the worksheet in excel but has made no
difference.

Do you have any other suggestions?

 

[Graham Mayor]

I don't think the dialogs changed between 2002 and 2003 - the change
occurred after 2000.
You will get the list of tables if you use OLE DB, ODBC or the converter.
DDE only shows the entire spreadsheet.
Turn off the confirm conversions option and try again.
If you use other converters than DDE you may have to use formatting switches
on your merge fields to convey the correct data
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Tracy at Axis]

Well something had changed, but your advice has worked - thank you. I did
need to use formatting switches to tidy the data up.