Mail Merge using Excel Database

[Alex Villari]

Hi,
Yesterday, my IT department installed my computer with MS
Word 2002 PS-2. I was using MS Word 2000. I have a
bunch of multi-worksheet Excel spreasheets that I use for
mail merges. I generally select a print area for a
particular range of data. In the new Word version, I
tried to do this and though it brought up a dialog box
that allows me to select the particular worksheet/print
area, when I click on the table, it subsequently brings
me to an empty dialog box with no tables. As a test, I
created a temporary new excel file with two records and
selected a print area. This time Word recognized the
print area as a table and I was able to proceed.
However, i have not been able to get it to work with any
of the actual Excel worksheets that I do mail merges
from. I don't know if my version of Word is faulty. Can
anyone help?

Please post responses or email me directly. Thanks.

Alex

 

[Alex Villari]

Thanks. I really appreciate it.

-----Original Message-----
Word 2002 changed the way Word connects to Excel from DDE to OLEDB. To do it
the old way - see
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_wo rd_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>






.