Hi



I am trying to do a mailmerge from a txt file.

I need a table style mail merge.

I have some static fields at the top of the letter and in the body I need to show a table of data. I also need headings at the top of the table for each field. When I tried to do this the headings kept repeating for each record.

Any help and code appreciated.

Many thanks

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327
http://windowssecrets.com/forums/sho...l=1#post928391
Although these examples use Excel data sources, the principles are the same.

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at https://skydrive.live.com/?cid=5aedc...615E886B%21566

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks

I tried this but how do you actually get the column headings in there and how to stop them repeating for every row?

By adding the column headings to the field codes where indicated and using a Catalogue/Directory merge rather than a Letter merge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Can you be more specific please?

It only says

The following example prefaces each City in the list with some introductory text, adds some headings and changes the format of the sales field.
[«City» «Representative» «Sales»
]
The fields laid out in this example produce the following output, using the ‘State’ field as the key field:
These are the sales totals for ACT
City Representative Sales
Canberra Yang $2,100.00

Nothing in there to state what is actually outputting the heading in bold.

It would appear you haven't read the tutorial's Introduction ... On page 1 is a discussion titled 'Viewing The Fields'.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul I've done that but all I see is

{MERGEFIELD State} {MERGEFIELD City}

Can you please state how I get the word 'State' and 'City' to appear as headings to this merge data?

Thanks

That would be because you didn't select the whole field - bounded by the [ ] characters for ease of boundary definition - before pressing SHift-F9. Try pressing Alt-F9.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]