Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2003

Tip: Looking for answers? Try searching our database.

Excel Data Source merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
IMH - 08 Oct 2003 19:18 GMT
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- - 11 Oct 2003 11:51 GMT
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
[quoted text clipped - 19 lines]
> 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 - 13 Oct 2003 17:41 GMT
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.

> Hi Imh,
>
[quoted text clipped - 38 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.