Excel Data Source merge

[IMH]

As I am not very literate in the use of Microsoft's mail merging, I am going
to try to explain my problem as best as I can. Here it goes:

I am attempting to perform a mail merge in Word 2000. I go to Tools / Mail
Merge, then choose document type = mailing labels, then I get a dialogue box
that instructs me to open data source with two options (1) merge from
address book and (2) Merge information from another type of file. I choose
2. I then attempt to open my Excel file and get a dialogue box that asks if
I want to use the entries in the first row of your data as field names. I
choose "yes". Note: The first row is the basic "First Name, Last Name,
Firm Name, Address 1, Address 2, City, State and Zip". Then I get a
dialogue box that says the data source has more than one worksheet or table
(? why, I don't really know) and instructs me to type the name of the
worksheet or table. I type sheet1 (as I know this is the name of the
worksheet?) and hit okay. I then get a dialogue box that says Word needs to
set up the merge document. I go to set-up and choose my label. However,
when I try to insert fields, all the field names are "NoName NoName1
NoName2, etc.? It gets more interesting. I close out of the dialogue box
and go to the Mail Merge Helper. My datasource now is listed as
C:\Windows\Temp\PJ23077.mbd. I then try the "get data" button again and
open data source. However, under File Types, I have no option for a MS
Excel file or a *.xls? When I choose the "all files" options under Header
Options / Open, I get an "Open Document in Workbook and have different
options such as "Entire Workbook, Sheet 1, etc., Name or Cell Range and a
check box for "Format Mail Merge". Whatever I choose I get the error
"unrecognized database format"?

I would appreciate any suggestions and I really apologize for the length of
this letter. Thank You

 

[Cindy M -WordMVP-]

Hi Imh,

Thank you for providing the details of how you've proceeded. I'm still not
sure I'm "looking over your shoulder" and seeing what you're seeing, but let's
try to sort this out

I have Tools/Mail merge in my Word 2000. But from that point on, things don't
coincide. Is your Word part of the Works Suite, by any chance? If it is, you
need to ask this in a WORKS newsgroup. Word as part of Works has a completely
different mail merge interface...

I am attempting to perform a mail merge in Word 2000. I go to Tools / Mail
Merge, then choose document type = mailing labels, then I get a dialogue box
that instructs me to open data source with two options (1) merge from
address book and (2) Merge information from another type of file. I choose
2. I then attempt to open my Excel file and get a dialogue box that asks if
I want to use the entries in the first row of your data as field names. I
choose "yes". Note: The first row is the basic "First Name, Last Name,
Firm Name, Address 1, Address 2, City, State and Zip". Then I get a
dialogue box that says the data source has more than one worksheet or table
(? why, I don't really know) and instructs me to type the name of the
worksheet or table. I type sheet1 (as I know this is the name of the
worksheet?) and hit okay. I then get a dialogue box that says Word needs to
set up the merge document. I go to set-up and choose my label. However,
when I try to insert fields, all the field names are "NoName NoName1
NoName2, etc.? It gets more interesting. I close out of the dialogue box
and go to the Mail Merge Helper. My datasource now is listed as
C:\Windows\Temp\PJ23077.mbd. I then try the "get data" button again and
open data source. However, under File Types, I have no option for a MS
Excel file or a *.xls? When I choose the "all files" options under Header
Options / Open, I get an "Open Document in Workbook and have different
options such as "Entire Workbook, Sheet 1, etc., Name or Cell Range and a
check box for "Format Mail Merge". Whatever I choose I get the error
"unrecognized database format"?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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

 

[IMH]

Thanks for your help. Yes my Word is part of Works suite. I'll seek help
in Works newsgroup. Thanks again. I didn't know it was a different Word.