Need to be able to repeat table lines...

[Rob]

I am trying to get word to merge this info in and I'm tearing my hair out with it

I have a csv file that looks something like this

customeraddress1,customeraddress2,customeraddress3,customeraddress4,invoiceline,invoiceitem,invoiceprice,invoiceqt
et
et
et

So, this is what I want to do

<<customeraddress1>><<customeraddress2>><<customeraddress3>><<customeraddress4>

** repea
<<invoiceline>> | <<invoiceitem>> | <<invoiceprice>> | <<invoiceqty>><<next record>
** until lastrecor

where the ** bits are things you don't appear to be able to do. This would give you an output of

10 Blah bla
blah de bla
bling blin
Bloomsvill

1 | Headache | £10.50 |
2 | Baldness | £100.20 |
3 | Eyestrain | £50.10 |
et
et

You get the idea? There doesn't appear to be a way of doing this. If someone could help I'd really appreciate it.

 

[Peter Jamieson]

Word doesn't make this easy to do - you may be better off working out how to
use Access (if you have it) to solve this. But see

http://homepage.swissonline.ch/cindymeister/

and look for Mail Merge FAQ, Special Merges, Multiple Items per condition

for starting points on ways to do it in Word.

--
Peter Jamieson - Word MVP

I am trying to get word to merge this info in and I'm tearing my hair out with it.

I have a csv file that looks something like this:

customeraddress1,customeraddress2,customeraddress3,customeraddress4,invoicel
ine,invoiceitem,invoiceprice,invoiceqty
etc
etc
etc

So, this is what I want to do.

** repeat
<<invoiceline>> | <<invoiceitem>> | <<invoiceprice>> |

** until lastrecord

where the ** bits are things you don't appear to be able to do. This would give you an output of;

10 Blah blah
blah de blah
bling bling
Bloomsville

1 | Headache | £10.50 | 1
2 | Baldness | £100.20 | 2
3 | Eyestrain | £50.10 | 5
etc
etc


You get the idea? There doesn't appear to be a way of doing this. If

someone could help I'd really appreciate it.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Um9i?=,

See the "Special merges" section of my website's mail merge FAQ. You'll find a shrot discussion tehre about the three
basic approaches available to you for 1-to-many listings, with links to sample files.

I am trying to get word to merge this info in and I'm tearing my hair out with it.

I have a csv file that looks something like this:

customeraddress1,customeraddress2,customeraddress3,customeraddress4,invoiceline,invoiceitem,invoiceprice,invoiceqty
etc
etc
etc

So, this is what I want to do.

<<customeraddress1>><<customeraddress2>><<customeraddress3>><<customeraddress4>>

** repeat
<<invoiceline>> | <<invoiceitem>> | <<invoiceprice>> | <<invoiceqty>><<next record>>
** until lastrecord

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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