Word Merge with Excel sheet datasource

[deepak.gupta@logica.com]

Hi,

I have one problem related to word merge, wherein my data source is excel sheet.


What I am currently doing, is generating a word document based on the data filled in a single row of the excel (data source).

• For example, I have the document with 26 merge fields as


1. Work package ID

2. Work package Description

3. Category

4. Work package assigned by

5. Work Package Assigned to

6. Work Package Assigned Date

7. Task_1

8. Task_2

9. Task_3

10. Task_4

11. Task_5 and so on till 20 tasks……


• So, I create a work package for my team member using the excel sheet and then just prepare the word document with quite a good description (as required) along with the merge fields appropriately. The teammate just refers to his word document and works on it, based on the appropriate tasks (which I keyed in the excel for that work package ID).

• The problem is, I may/may not have 20 tasks for each work package ID, so it leaves many blank rows in the document, given to teammate and also increase the size of the workbook.

• What I am looking for: Instead of depending on the single row with multiple columns (filled and blank), can I not depend on a key value (here Work package ID) and have multiple rows for tasks? This will limit the no. of columns to 7, and will appropriately fill the document with the same no. of rows as the no. of rows in the excel (data source).

1. Work package ID

2. Work package Description

3. Category

4. Work package assigned by

5. Work Package Assigned to

6. Work Package Assigned Date

7. Task


Let me know, if you can help.


Thanks in advance


Deepak

 

[deepak.gupta@logica.com]

Anyone, any inputs?

 

[vasim]

I think you should upload the word doc along with excel for some good result. For uploading you can use....


http://chandoo.org/forums/topic/posting-a-sample-workbook