A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Column headers in catalog merge?



 
 
Thread Tools Display Modes
  #1  
Old June 23rd, 2004, 07:25 PM
Neil Dittmar
external usenet poster
 
Posts: n/a
Default Column headers in catalog merge?

Hello All,

I am using the mail merge features in Word 2000 with the
main document type as Catalog to produce a 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 tell Word (either in
the main document or during the merge process) that the
column headers should only be displayed once (ie; not
repeated). If anybody has any information on how to do
this, it would be greatly appreciated.

Thanks,

Neil Dittmar
Software Developer
Aurora Information Systems
  #2  
Old June 24th, 2004, 08:28 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default Column headers in catalog merge?

Merge to a new document and then add the extra information you wish to
display.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Neil Dittmar wrote:
Hello All,

I am using the mail merge features in Word 2000 with the
main document type as Catalog to produce a 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 tell Word (either in
the main document or during the merge process) that the
column headers should only be displayed once (ie; not
repeated). If anybody has any information on how to do
this, it would be greatly appreciated.

Thanks,

Neil Dittmar
Software Developer
Aurora Information Systems



  #3  
Old June 24th, 2004, 10:24 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default Column headers in catalog merge?

You have to add them after the merge. It could be done with a macro.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Neil Dittmar" wrote in message
...
Hello All,

I am using the mail merge features in Word 2000 with the
main document type as Catalog to produce a 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 tell Word (either in
the main document or during the merge process) that the
column headers should only be displayed once (ie; not
repeated). If anybody has any information on how to do
this, it would be greatly appreciated.

Thanks,

Neil Dittmar
Software Developer
Aurora Information Systems


  #4  
Old June 24th, 2004, 07:12 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Column headers in catalog merge?

Hi Neil,

I am using the mail merge features in Word 2000 with the
main document type as Catalog to produce a 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:

For a table, you could put a row with column headers in the
HEADER portion of the main merge document. Getting it all
lined up can be a bit tricky, you may need to put that row in
a text box and format it "behind the text".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding an Offset to a Column Value SidBord Worksheet Functions 2 April 17th, 2004 07:21 PM
Excel functions help Norman Harker Worksheet Functions 3 February 6th, 2004 06:31 PM
Convert a Column List Into a Row of Headers Frosty Worksheet Functions 1 December 15th, 2003 10:14 PM
MS Excel Column Headers Naming Jeff Winterstein Setting up and Configuration 1 October 8th, 2003 02:25 PM


All times are GMT +1. The time now is 08:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.