Column Headers in Catalog Merge?

N

Neil Dittmar

Hello All,

I am programatically using the Word 2000 Object Model to
execute a mail merge via a Visual Basic program. The main
document type is set as Catalog and the output produces a
single table with invoice payment line items. The table
is created successfully after the merge, however I would
like to be able to put column headers on the table as
well. If I add column headers to the main document and
then merge, I end up with the headers being repeated in
every other row of the table. For example:

Headers
First Payment line item
Headers (Repeated)
Second Payment line item
Headers (Repeated)
Third Payment line item
etc...

I was wondering if there was a way to designate that the
column headers should only be displayed once (either
programatically via the Word object or in the main
document itself). If anybody has any information on how
to do this, it would be greatly appreciated.

Thanks,

Neil Dittmar
Software Developer
Aurora Information Systems
 
J

Jean-Guy Marcil

Bonjour,

Dans son message, < Neil Dittmar > écrivait :
In this message, < Neil Dittmar > wrote:

|| Hello All,
||
|| I am programatically using the Word 2000 Object Model to
|| execute a mail merge via a Visual Basic program. The main
|| document type is set as Catalog and the output produces a
|| single table with invoice payment line items. The table
|| is created successfully after the merge, however I would
|| like to be able to put column headers on the table as
|| well. If I add column headers to the main document and
|| then merge, I end up with the headers being repeated in
|| every other row of the table. For example:
||
|| Headers
|| First Payment line item
|| Headers (Repeated)
|| Second Payment line item
|| Headers (Repeated)
|| Third Payment line item
|| etc...
||
|| I was wondering if there was a way to designate that the
|| column headers should only be displayed once (either
|| programatically via the Word object or in the main
|| document itself). If anybody has any information on how
|| to do this, it would be greatly appreciated.
||

Just a long shot.... (Haven't done mailmerge in a long time, don't remember
if my suggestion will work!)
Have you tried putting the table headers in the document header, aligned
with the table itself?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
G

Guest

Thanks for the reply, however I don't think I'm able
to use your suggestion. Although placing the column
headers in the page header may work (I'd need to play
around with the page formatting so they are flush with the
table), I am actually using the resulting merge file in
another document as a linked file. Therefore, the page
headers on the linked file will not display on the
document that it is linked to. Thanks for taking the time
to reply.

Does anybody else have any suggestions?

Thanks,

Neil Dittmar
Software Developer
Aurora Information Systems
 
J

Jean-Guy Marcil

Bonjour,

Dans son message, < (e-mail address removed) > écrivait :

| Thanks for the reply, however I don't think I'm able
| to use your suggestion. Although placing the column
| headers in the page header may work (I'd need to play
| around with the page formatting so they are flush with the
| table), I am actually using the resulting merge file in
| another document as a linked file. Therefore, the page
| headers on the linked file will not display on the
| document that it is linked to. Thanks for taking the time
| to reply.
|
| Does anybody else have any suggestions?
|

Are you doing the merge through VBA?
If so, add the header row after the merge is done (Autotexts are useful for
that).

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 

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