Merge from Excel database to WORD List

[kathywmn2]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I want my database to end up in WORD as a list (not labels, not envelopes, not letters - don't know what a catalog is). I can't seem to find how to do this. The various "Add*" fields I'm trying don't seem to work ... it just puts the next record on the next page. How do I create a LIST from my database where all record are on one or more pages one after the other with no page breaks, etc.???

 

[CyberTaz]

Hi Kathy -

Actually you have several options - one is the Catalog feature you
mentioned. It's intended for that type of result - merging multiple records
per page - but typically for catalogs, directories, detailed price lists,
etc.

Another option: What about good old Copy/Paste? Select & copy the records in
Excel, then in Word use Edit> Paste Special - pick a format... Formatted
Text will render a Table, Unformatted Text will render a tabular list, or
you can choose Excel Sheet Object. Picture & PDF are available as well if
the content needn't be editable.

A 3rd: Just because you merge using a Label format doesn't mean you need to
*print* on label sheets. A label document is nothing more than a table with
one record per cell. By default the table borders don't display or print &
as long as the paper size matches Word doesn't care if you print on label
sheets or burlap sacks