Merge to table

N

Ned Merrick

I have created a document with a table. How can I merge a database to that
table so it doesn't insert the first record over and over?
 
J

John McGhie [MVP - Word and Word Macintosh]

Ned:

You can't.

Export the database to a Tab-separated text file, open the file in Word, use
Table>Convert>Text to table to convert the text to a table.

Then click in the first cell of the table you have prepared and "Paste".

Cheers


I have created a document with a table. How can I merge a database to that
table so it doesn't insert the first record over and over?

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410
 
P

Peter Jamieson

What kind of database?

You can try the following if you want, but you may find that you end up
having to re-apply your formatting anyway:
a. Enable the Database menu (Tools|Customize|Customize Toolbars/Menus)
b. Use the Insert Database icon to insert your data (if it isn't in a
format Word can work with, such as a Word table, an Excel worksheet, or a
comma-delimted text file, then you will need to export it from your database
first). You can apply some Autoformatting using one of the dialog buttons.
Ensure you insert the data as a field.
c. If you want more specific formatting, try the following (no guarantees
that it will work):
- apply the fomatting you want
- reveal the field codes, e.g. using the Data Merge Manager dialog box
icons. You will see something like

{ DATABASE blah blah }
- type \*Mergeformat before the }
so you have
{ DATABASE blah blah \*Mergeformat }

Try re-executing the field.

Then you don't need a merge.

If you need to use a merge, use a Catalog merge and just do the layout for
one row. Do not have anything else in the document. Do the merge to a new
document, and add the header row manually.

Peter Jamieson

Are you trying to preseve the layout of a predefined form, or would it be
enough to use one of Word's predefined table layouts?
 
D

Daiya Mitchell

Yeah, I kinda want to know what the table looks like. It should be
possible to merge into a table, because that's how Word creates labels,
but it's not clear what you are doing. You might see if using one of the
label setups works.

Peter Jamieson wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top