Mail Merge into Microsoft Word using Microsoft Access as data sour

[Guest]

On my computer I have no trouble using Microsoft Access queries as my data
source for simple mail merge letters or mailing lists in Word. Using the
mail merge wizard I select the data source which my computer shows as All
Data Sources (*odc; *mdb; *mde; and so on). I select it and then select my
Access database and Word shows me whatever query I selected as my data source
or as Word puts it "receipients".

However, on my partners computer, using the mail merge wizard, we select the
data source which on her computer shows All Data Sources - but not the list
of all types of data. The wizard then forces her to click the "New Sources"
and in it she has to select the "ODBC DSN" tab opening another window where
we choose MS Access Database as our data source followed by another window
that lets her select the database source she wants.

Why the difference? Is there something in the preferences or properties on
her computer that hasn't been selected? Why would she have so many extra
steps in an otherwise simple mail merge process?

 

[Guest]

You might check your partner;s computer to verify the ODBC link to the data
source is set up the same as it is on work station. If have any problems
setting up the ODBC driver on their computer, you could select to share yours
as a data source.

 

[Larry Daugherty]

And.... since your issues arises in Word, your post really belongs in
a Word newsgroup, not Access.

HTH

 

[Guest]

Hope my response was helpful for you and your partner. I've found that
getting the ODBC drivers set to read another database through Access is a
pain at best, but sometimes the one thing overlooked.

Kristi