how to code a macro for creating a table in word and fill the colums with data ?

HELLO

I want a write a code in excel macro for

1.Create "n" new word document with column A in excel as file name

2.Inside each word file

ID Number A1,2,3,4,5..
Theme B1,2,3,4,5..
Type of article C1,2,3,4,5...
Keywords D1,2,3,4,5..
Word Count E1,2,3,4,5
Guideline link F1,2,3,4,5
Sample Link G,1,2,3,4,5

i want the file to be named as 1 and inside the file 1 the table must contain
ID Number A1
Theme B1
Type of article C1
Keywords D1
Word Count E1
Guideline link F1
Sample Link G1

in file 2 file name 2
ID Number A2
Theme B2
Type of article C2
Keywords D2
Word Count E2
Guideline link F2
Sample Link G2

these are the things that has to be in the word document

can you please help me...

Hi Giri,

Why would you not use the Mail Merge for this requirement. Except for the part of saving the each file as an individual file, mail merge can do the above for you.

Regards

Chuck

Did you notice the date on the post, Chuck?

Hi Cutter,

Did notice the date. I generally do avoid anything that is more than a week old. But as I was surfing thru an MVP's page I saw his kinda SOS. I thought of looking at the link to see if there were other responses. But the time I noticed the date, I had posted my response.