How to Merge THREE worksheets from EXCEL 2000 into Word 2000

[kam]

I hope someone could help. I have names and addresses on THREE Excel worksheets (these worksheets are saved as one file) and i want to merge all THREE worksheets with Word. In Word i have a letter written up, which needs to go out to all these people on theses worksheets. Is there a way to merge ALL THREE worksheets at once? Thanks in Advance.

 

[cherria]

You would need to write a macro in Word VBA that changed the data source from one sheet to the next.

 

[kam]

Re: How to Merge THREE worksheets from EXCEL 2000 into Word

Any ideas how to do this? I do not have much knowledge in VB. Appriciate your help.