Macro to export cells to word doc

[aserle]

Hi,

I'm currently running a project at work where I have a column of words (in alphabetical order).

I'm trying to create a macro that will 1) create (and automatically save) a word document for each letter (A.doc, B.doc, C.doc) and then 2) copy in the words starting with each letter, but also 3) as part of a template that's located in another cell.

To try explain further:

Template Cell: Hi my name is

Name:
Aaron
Andrew
Bob
Steven
Ted

a.doc would contain the text

"Hi my name is Aaron
Hi my name is Andrew"

Apologies is this is very simple, but this aspect of vb programming is very new to me!

Any help would be greatly appreciated

thanks,

Andrew

[ARGK]

Hi Andrew
With the limited information you have provided I would suggest that you don't need a Macro. What you need to do is use Mail Merge within MS Word using your Excel worksheet as the data source.
Tony