Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Multi-line csv
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Multi-line csv
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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 or at: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "David J" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Multi-line csv
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 "Doug Robbins - Word MVP" wrote: 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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 or at: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "David J" wrote in message ... 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Multi-line csv
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 "David J" wrote: 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Multi-line csv
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. -- 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 "BrantleyMc" wrote in message ... 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 "David J" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-line equations in Word 2007 | Microsoft Word Help | |||
Multi line Drop Down Form Field | Microsoft Word Help | |||
Can I have multi-line items in a drop down box? | Microsoft Word Help | |||
Merging multi-line fields | Mailmerge | |||
multi line TOC entry | Microsoft Word Help |