Generate word files from Excel sheet

[abbver98]

Can someone help with this ?
I have an excel spredsheet with Lines Xi and columns Yj.
in Cells X1, Y2 to n : I have the name of files that I want to generate.
in cells X2 to m, Y1 : I have the text that I want to put in all the file
in cells X2 to m, Y2 to n : the data that I want to put in the file X1,Yj

I need program that generate a word file with name in X1,Yj cell, name of data in X1, Y2 to n cells and the value of the data in X 2 to n,Yj.

Who can help

 

[IRstuff]

That's what VBA is for. I suggest you do a search, since this subject has been discussed in the spreadsheet forum already.

TTFN
faq731-376

 

[LiteYear]

I can help. Let me know where you get stuck.

 

[FrancisL]

Search for
word mail merge excel data source

Francis

http://www.controldraw.co.uk

http://www.s88control.blogspot.com