Merge Multi-line csv

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David J - 12 Nov 2007 19:16 GMT

I'm trying to merge a csv of my website orders into despatch notes I've
created in Word 2003 - it's easy to merge single-line 'flat' data such as
Order No, Name, Addr1, etc...but the problem is that each record has a
sub-set of fields, showing 'item ordered' 'qty' 'price' etc. Each of these
'sub-columns' can have a variable amount of rows depending on how many items
a customer has ordered.

Looking at the csv in Excel, it has * at the end of each 1st (flat) row and
then around the further rows that show the item details (dynamic), with
records separated with 2 rows.

Any ideas on how to merge each dynamic 'Product' field into Word before
moving to the next record?

It's hard to explain but I hope you get the gist of the problem.

DJ

Reply to this Message

Doug Robbins - Word MVP - 13 Nov 2007 03:21 GMT

This is far more easily done in Access.

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm trying to merge a csv of my website orders into despatch notes I've
> created in Word 2003 - it's easy to merge single-line 'flat' data such as
[quoted text clipped - 16 lines]
>
> DJ

Reply to this Message

David J - 13 Nov 2007 18:05 GMT

Hi Doug

Thanks a lot for the links, I've been through them but think I have to admit
defeat on a 'cost of my time to find out how' versus 'cost of someone else
doing it' basis - will be in touch!

David

> This is far more easily done in Access.
>
[quoted text clipped - 34 lines]
> >
> > DJ

Reply to this Message

BrantleyMc - 03 Nov 2008 14:04 GMT

Hello,
I followed the instructions in Microsoft Article 211303. I could make it
work but this technique is NOT for your average Word User. Is anyone aware
of new features available in Office 2007 that may facilitate this process?

Thanks,
Brant

> I'm trying to merge a csv of my website orders into despatch notes I've
> created in Word 2003 - it's easy to merge single-line 'flat' data such as
[quoted text clipped - 13 lines]
>
> DJ

Reply to this Message

Doug Robbins - Word MVP - 03 Nov 2008 19:01 GMT

No, nothing has changed in respect of the ability to do a merge where there
are multiple records containing data that pertains to the information in one
or more key fields.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello,
> I followed the instructions in Microsoft Article 211303. I could make it
[quoted text clipped - 25 lines]
>>
>> DJ

Reply to this Message