Copy excel contents to word

Hi -
Is it possible to automate the process of copying cells from excel to a word documet? For example: I have first name and last names in two colums in excel and I would like to copy the first and last names to a Word template.

Please suggest!

Thanks,
Ritu

Try this!

Please Login or Register  to view this content.

Regards,
Simon

Hi Simon,

This works great but I do have another question. When I call the GetObject function as follows, it does not open my word document. Do you know why this would be? Am I missing something?


Set appwd = GetObject("c:\WordName.doc")

Thanks,
Ritu

Try this:

Please Login or Register  to view this content.

Regards,
Simon

Thank you for helping me with this..

I actually get the following Run Time error:

Run time error: '438'
Object doesn't suppport this property or method.

Any ideas why?

Thanks,
Ritu

Which line does the code stop on?, i didn't test the code just knocked it up!

Regards,
Simon