Excel Sheet & Mail Merge

R

Rick

I am using excel as a data base. I have set up sheet #2
to extract data to use in a Word mail merge document.
My question is "How do I tell Word that my data is in
Sheet #2?"

Thanks for your help.
 
D

Dave Peterson

You could try giving your range on sheet2 a nice range name.

But I've always had better success by just rearranging (temporarily??) the
worksheets.
 
M

Mike A

I am using excel as a data base. I have set up sheet #2
to extract data to use in a Word mail merge document.
My question is "How do I tell Word that my data is in
Sheet #2?"

Thanks for your help.
Click to expand...


You could either name the range your database is in:

Select sheet2. Select the entire range of your database, including
column headers. In the name box (left of the formula bar; it says
something like A1 in it), type a name for the database such as
maillist. Do not use 'Database' for the name - Word will not see your
data if you do!

This name will show up as a table name in your mailmerge data source
dialog.

-------------------------------


Or, you could create an ODBC connection to your Excel file:


When you do your mail merge, select 'Create Data Source' then click on
the MSQuery button. (You may need your installation CD the first time)

Excel sheets are accessed with the sheet names as system tables, which
by default are excluded from the query. You need to activate them
when you specify the file:

Select Excel files, and navigate to and select the file your data is
in. Click OK. Click the 'Options' button in either the MSQuery
Wizard or the Add Tables dialog, whichever you are using. Select
'System Tables'

Now you can select sheet2 and your database fields will be available
for your query.

You can save this query and re-use it later with far less effort!




Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
Top