csv to Word populating
I have a number of fields from a database that I plan on exporting into a csv on a regular basis. I would then like the different fields to be populated into a word document (or similar) in a particular style.
eg The Sheet would look like this, with the column headings in bold. Under each heading is a series of names/codes (probably about 30 or so under each header.
FIELD 1 FIELD 2 FIELD 3 FIELD 4
Test1 TestA Test& Test^
Test3 Test( Test* TestT
I would then like to populate a document that looks like below. With the idea being that this information could then be cut and pasted into an email. So I deally I would like that to be in a Word document or similar.
Test1
TestA
Test&
Test^
Test3
Test(
Test*
TestT
Can anyone advise on the best way to acheive this and make it as easy as possible so this can be done quickly on a weekly basis.
LB
|