Excel to Word Letter - possible mail merge?

[mikey3580]

Hi,

Having never used mail merge, I am not sure if that is the way to do this. I have am excel file with over 500 addresses in column K. I have the Name of the person in column C and the the Subject in column H and Subject 2 in column I.

I have a word template that I want to use. What I would like to do is insert each piece of information from the excel file into the appropiate spot on the word doc template, save the word doc in the appropiate folder, close word doc, open template again and repeat for over 500 times. Essentially creating 500 word docs with addresses.

Any thoughts on a good way to do this? Anyone have experience with doing something like this or code that I can alter to perform this action?

I read a little about mail merge, but not sure if that is going to do what I need in a quick manner.

Thanks

[Sc0tt1e]

I believe Mail Merge is the way to go, I am have a similar issue but not getting many responses on the issue.

I have found some code about getting the mail merge to run but you seem to need to set up the connectivity before hand and this is where I am struggling to understand the steps involved when trying to create a VBA driven mail merger.

LJMetzger was kind enough to point me in the direction of an earlier post of his/hers that they posted some time back which again provides code but no real basic fundamental direction for creation/steps required. I have provided the link below in case it is of help to you.

See the sample files associated with post #4 of the following thread: http://www.excelforum.com/excel-prog...merge-doc.html

[mikey3580]

Link doesn't work. Appreciate it!

[Sc0tt1e]

Scroll to the bottom of this page and you will see a post by me called "VBA Mail Merge", a working link is in there.