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 / February 2007

Tip: Looking for answers? Try searching our database.

merge using excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dannie - 16 Feb 2007 17:28 GMT
Hi, I hope you can help me.  I am trying to merge using Excel as a database.  
No matter which "conversion" choice I use, it still says it cannot open the
excel document.

Thanks,
Signature

dannie

Peter Jamieson - 16 Feb 2007 21:52 GMT
Which version of Word and Excel?

What version of Excel was the Workbook created in? Is it password-protected?

Does your data consist of a worksheet with column headers or what?

If you export the data you want to use to .csv format, then re-import it
into a new workbook, can you connect to that?

Peter Jamieson
> Hi, I hope you can help me.  I am trying to merge using Excel as a
> database.
[quoted text clipped - 3 lines]
>
> Thanks,
dannie - 19 Feb 2007 22:25 GMT
Thank you.  The .csv part worked - on MS Office Teacher-Student edition,
which both the excel & Word documents were created in.  It did not work on my
2000 office.

NOW I am making a directory & it wants to put each person's data on one page
each.  (I found several references to working with labels, but they did not
work.) I finally found the fields to insert, so inserted Next Record, but
that didn't work.  Do I need to add the fields again?

Thanks so much!!!
ds
Signature

dannie

> Which version of Word and Excel?
>
[quoted text clipped - 13 lines]
> >
> > Thanks,
Peter Jamieson - 20 Feb 2007 08:29 GMT
> It did not work on my
> 2000 office.

Are you stil ltrying to solve this problem? Is your Teach-Student edition
Office XP (2002) or 2003? Using an Excel XP/2003 data source with Word 2000
may well cause problems.

> NOW I am making a directory & it wants to put each person's data on one
> page
> each.  (I found several references to working with labels, but they did
> not
> work.) I finally found the fields to insert, so inserted Next Record, but
> that didn't work.  Do I need to add the fields again?

Typically, for a directory, you need to specify that the merge type is
Catalog (Word 2000) or Directory (Word XP/2003). In Word 2000 you can do
that in the first step in the Mail merge helper. In Word XP/2003 it is
usually easiest to enable the Mail merge toolbar (Word Tools|Customize) then
select the merge type using the first button in the toolbar.

When you create a catalog (or directory) type merge, you should lay out the
fields how you want and /not/ use any Next Record fields. You would
typically have a blank paragraph at the end of your mail merge main
document. When Word merges, it should produce a new document that does not
have ppage breaks of any kind between the records.

If you really need to use a label type merge, then you do have to copy the
fields you have placed - each label in your layout needs its own copy of
those fields. There should be one Next record field before each "label"
except the first one.

Peter Jamieson
> Thank you.  The .csv part worked - on MS Office Teacher-Student edition,
> which both the excel & Word documents were created in.  It did not work on
[quoted text clipped - 29 lines]
>> >
>> > Thanks,
dannie - 20 Feb 2007 12:50 GMT
Thank you so much!.  Yes, I will work on it again today!  But this should
take care of it I hope.  

Thankyou!
Signature

dannie

> > It did not work on my
> > 2000 office.
[quoted text clipped - 61 lines]
> >> >
> >> > Thanks,
 
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.