Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2003

Tip: Looking for answers? Try searching our database.

Need to be able to repeat table lines...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rob - 26 Nov 2003 15:36 GMT
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
:-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.