Insert Header Row In Table During Merge

M

Michael Koerner

Is it possible when merging into a table, during the merge when the LName field
first character changes from A to B to C...that a new row could be inserted and
formatted so that the output would look similar to the following.
 
P

Peter Jamieson

As long as you want the output in tabular format, I think you will need some
VBA however you do it, if only to remove empty rows between tables. From
previous messages my guess is that that's a turn-off :)

However, if you do not actually need to use table rows, you could do this
sort of thing using a catalog/directory merge. But I don't think you could
do that, then use Table|Convert text to table, unless you were willing to
accept that the rows containing "A", "B" would actually have the same number
of columns as the Adams, Arthur rows.

Peter Jamieson
 
M

Michael Koerner

Peter, thanks. What I do now, after the merge, scroll through the table. When
the first character of the last name changes, I insert a row, and insert the
upper case character of the names to follow. I don't know VBA so that is out.
This was so simple in WordPerfect. you just entered then code in the merge
parameters.

--

Regards
Michael Koerner


As long as you want the output in tabular format, I think you will need some
VBA however you do it, if only to remove empty rows between tables. From
previous messages my guess is that that's a turn-off :)

However, if you do not actually need to use table rows, you could do this
sort of thing using a catalog/directory merge. But I don't think you could
do that, then use Table|Convert text to table, unless you were willing to
accept that the rows containing "A", "B" would actually have the same number
of columns as the Adams, Arthur rows.

Peter Jamieson
 
P

Peter Jamieson

This was so simple in WordPerfect. you just entered then code in the merge
parameters.

Irritating, isn't it?

Quite a lot more things would at least be feasible without VBA if it were
possible to use Find/Replace to remove empty paragraphs between table rows,
but as far as I know even that requires VBA...

Peter Jamieson
 
M

Michael Koerner

Quite irritating at times. Thanks for all the help.

--

Regards
Michael Koerner


Peter Jamieson said:
This was so simple in WordPerfect. you just entered then code in the merge
parameters.

Irritating, isn't it?

Quite a lot more things would at least be feasible without VBA if it were
possible to use Find/Replace to remove empty paragraphs between table rows,
but as far as I know even that requires VBA...

Peter Jamieson
 

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