J
Jan
I need to transfer a database file from access to Excel and hten do a mail
merge
merge
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JLatham
You can get the contents of any table imported into an Excel worksheet a
couple of ways.
From Excel, choose
Data | Import External Data | Import Data
Then browse to the .mdb file and identify it and choose from the tables
displayed.
From Access you can open a table or query and then choose File | Export and
choose the .xls file type. An Excel workbook with a single sheet will be
created. Both the workbook and the worksheet will have the name of the table.
Eventually you'll end up over in Word and during the Mail Merge process,
just identify the Excel workbook as your data source.
couple of ways.
From Excel, choose
Data | Import External Data | Import Data
Then browse to the .mdb file and identify it and choose from the tables
displayed.
From Access you can open a table or query and then choose File | Export and
choose the .xls file type. An Excel workbook with a single sheet will be
created. Both the workbook and the worksheet will have the name of the table.
Eventually you'll end up over in Word and during the Mail Merge process,
just identify the Excel workbook as your data source.
G
Gord Dibben
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/MailMerge/CreateAMailMerge.htm
http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
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/MailMerge/CreateAMailMerge.htm
http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm
Gord Dibben MS Excel MVP
I need to transfer a database file from access to Excel and hten do a mail
merge
Gord Dibben MS Excel MVP
J
JLatham
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/WordMailMergeWithExcelDataSource.xls
if you feel the quality is good enough, feel free to provide links to it
anytime.
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/WordMailMergeWithExcelDataSource.xls
if you feel the quality is good enough, feel free to provide links to it
anytime.