I've used mail merge in the past, but mostly for very basic, well, mail (letters).
This time, I'm trying to do something a little different.. and not really for mailing purposes.
Source: Excel (.xls) file. Sheet1. Column names:
ID, Type, Request, Additional Information
What I'm looking to get is a Word Document with tables like:
---------------------------------------------------------
| Type |
----------------------------------------------------------
| Request: | [ID] - [list of all requests that are |
| | [of the same type] |
---------------------------------------------------------
| Additional | [ID] - [corresponding list of extra |
| Info: | [info relating to each request] |
---------------------------------------------------------
So, sample excel:
1, NameList, List names, List all names alphabetically
2, NameList, Delete option, Be able to delete names
And word document:
---------------------------------------------------------
| NameList |
---------------------------------------------------------
| Request: | 1 - List Names |
| | 2 - Delete option |
---------------------------------------------------------
| Additional | 1 - List all names alphabetically |
| Info: | 2 - Be able to delete names |
---------------------------------------------------------
Can anyone start pointing me in the direction I should be taking this? What I do know how to do is:
NameList
[request1], [additional info1]
[request2], [additional info2]
But I can't figure out how to break it up into the table like I have above.
Please any advice/tips. Thanks.