One more potential source for information on setting up in Word to use Excel
as a Mail Merge data souce is an Excel workbook with step by step
instructions that I prepared to assist another person with such a request
elsewhere recently. That document can be found at
http://www.jlathamsite.com/Teach/Wor...DataSource.xls

if you feel the quality is good enough, feel free to provide links to it
anytime.

"Gord Dibben" wrote:

I would suggest you do the mailmerge in Word.

You can use the Access DB as source.

No need to involve Excel if you don't want to.

If you do want to use Excel, see JLatham's post.

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP



On Fri, 7 Jul 2006 07:52:02 -0700, Jan wrote:

I need to transfer a database file from access to Excel and hten do a mail
merge

Gord Dibben MS Excel MVP