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 - 27 Nov 2003 11:22 GMT
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.
<<customeraddress1>><<customeraddress2>><<customeraddress3>><<customeraddres
s4>>
> ** repeat
> <<invoiceline>> | <<invoiceitem>> | <<invoiceprice>> | <<invoiceqty>><<next record>>
[quoted text clipped - 14 lines]
>
> 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- - 27 Nov 2003 12:13 GMT
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.
>
[quoted text clipped - 12 lines]
> <<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
:-)