Excel data into Word table

M

Melinda

When I merge data from Excel into a Word table, Word inserts a section break
between each row causing each row to be on a separate page. I've tried
searching for the break and replacing it with nothing, but that doesn't work
and I am having to manually delete each one. How do I stop Word from
inserting the breaks?
 
D

Doug Robbins

Instead of a formletter type mailmerge main document, use a catalog (or in
Word XP and later, it is called "directory") type mailmerge main document in
which you have a one row table into the cells of which you insert the
mergefields. When you execute the merge to a new document, that document
will contain a table with a row for each record in the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

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