Print a bunch of letters using data from an excel file

[edgarq]

I need to print a bunch of letters (MS-WORD) using some data which is in a file (MS-EXCEL). How can I do this via macro?

Regards,
Edgar

 

[Norie]

Edgar

Do you really need code?

Can't you use the Excel spreadsheet as a source for a mail merge in Word?

 

[edgarq]

Hi Norie,

I have never done these merge option in Word... I am going to try it.
Any additional suggestion ?
Thanks,

Edgar

 

[Smitty]

Mail Merge is probably the best way to go and is pretty straightforward. (in Word), just goto Tools-->Mail Merge and follow the Wizard from there.

Smitty

 

[edgarq]

Certainly, Mail Merge is the solution.
Thanks

Edgar