mailmerge with Excel as data source

[susan christensen]

Using Excel '97 and Word '97 -- I'm trying to specify sheet 2 of an Excel
worksheet for my mail merge. I haven't been successful. The merge always takes
the data from the first sheet in the file regardless of what I specify in the
window that comes up after opening the data source. (Header line is the same on
both worksheets.)

Suggestions??

[Astrid]

Hi Susan,

Activate the 'Select method' checkbox in the Open data source dialog. Choose
Microsoft Excel Worksheet via Converter. A new dialog pops up now 'Open
Worksheet'. It has a listbox to select the open document in Workbook, select
the desired sheet and press ok.

Hope this helps,
regards,
Astrid

So that all can benefit from the discussion, please post all follow-ups to
the newsgroup.
Visit the MVP Word FAQ site at http://www.mvps.org/word/

"susan christensen" <sus...@crackerbarrel.com> schreef in bericht
news:094e01c0de13$9e686300$a5e62ecf@tkmsftngxa07...

[susan christensen]

Thanks! That worked great -- one time (!?) Now, everytime I try any mailmerge,
I keep getting an error code that reads:

"Word could not merge the main document with the data source because the data
records were empty or no data records matched your query options."

All the data sources DO have data and I'm NOT doing a query. I'm baffled!

-----Original Message-----
Hi Susan,

Suggestions??

.

[Cindy Meister -WordMVP-]

Hi Susan,

> Now, everytime I try any mailmerge,
> I keep getting an error code that reads:
>
> "Word could not merge the main document with the data source because the data
> records were empty or no data records matched your query options."
>

Could you describe the steps implied in "every time I try any mail merge",
please?

Did you, at any time before executing the merge, use the "Find record" button
(the binoculars)?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://www.mvps.org/word
http://go.compuserve.com/MSOfficeForum

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[hkbs]

Hello Astrid
I have the same problem as Susan - but I don't have the option to 'Select
method' in the Open data source dialog. Any ideas, please?

Anne

Astrid <ast...@mvps.org> wrote in message
news:OGaWwJj3AHA.992@tkmsftngp07...

[Cindy Meister -WordMVP-]

Hi Hkbs,

> I have the same problem as Susan - but I don't have the option to 'Select
> method' in the Open data source dialog.
>

Every version of Word since 6.0 has this check box. Look again in the
dialog box where you select the data source you want to use with the mail
merge. It's the only checkbox in the dialog box...