Re: merge using excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
"dannie" <dannie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1BEFF2F3-4F74-4B86-9D2C-7BB624877571@xxxxxxxxxxxxxxxx
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
--
dannie


"Peter Jamieson" wrote:

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
"dannie" <dannie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:855B1F91-4819-4482-AF0D-242896D69331@xxxxxxxxxxxxxxxx
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,
--
dannie





.

Relevant Pages

  • Re: Printing Variable Label Quantities from a Merge
    ... From this point, the simplest approach is probably either to use the Excel macro I provided, and link /that/ sheet into Access, or stick with Word if you do not want to get any further into Access. ... "Peter Jamieson" wrote: ... its label generator may be worth investigation ...
    (microsoft.public.word.docmanagement)
  • Re: merge using excel
    ... "Peter Jamieson" wrote: ... If you really need to use a label type merge, then you do have to copy the ... What version of Excel was the Workbook created in? ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Printing Variable Label Quantities from a Merge
    ... "Peter Jamieson" wrote: ... more Excel sheet or Access table and a query, but at the moment I don't ... its label generator may be worth investigation ...
    (microsoft.public.word.docmanagement)
  • Re: mailmerge with txtfile
    ... I did not recognise the format as DIF. ... My assumption is that Excel does not know what to do with the LABEL ... Then go into the Open Data Source dialog (Select Data Source in Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: merge is pulling in every other record?
    ... I should have said KillmapS ... "Peter Jamieson" wrote: ... and the excel spreadsheet for you to look at. ... The first two records (labels) merge fine - top left label, ...
    (microsoft.public.word.mailmerge.fields)