My Data Base will Not open in Publisher Mail Merge

[Joe]

When I try to Merge a Data Base into a Publisher piece heres what i get:

The data source you have chosen contains more than one worksheet or table.
Please enter the name of the worksheet or table that contains the
information you want to merge.

I have NO IDEA what its asking me for. Publisher Help doesn t seem to have
the answer, the co. that I bought the Data from has no idea. She sent it in
CSV format if that helps. Thanks (e-mail address removed)

 

[Rob Giordano \(Crash\)]

Sounds like it has move than one worksheet in an Excel file. Make a backup
copy, then open it with Excel, if it has more than one worksheet delete the
extra worksheets if they are empty, they probably are.

If they are not empty make separate Excel files out of each worksheet and
save them with different names each having onlly one worksheet.

OR see what the name of each sheet is and enter it as per the error...if
they're at default names it'll be something like sheet1, sheet2,
sheet3...etc.

That 'should' work.




| When I try to Merge a Data Base into a Publisher piece heres what i get:
|
| The data source you have chosen contains more than one worksheet or table.
| Please enter the name of the worksheet or table that contains the
| information you want to merge.
|
| I have NO IDEA what its asking me for. Publisher Help doesn t seem to have
| the answer, the co. that I bought the Data from has no idea. She sent it
in
| CSV format if that helps. Thanks (e-mail address removed)