Generate Word documents out of Excel

Hi,

I have an Excel document and I’d like to have an Excel Macro generate word documents for each line of my excel document.

Ideally the Macro would directly fill out the word template and save it.

Can someone help me out?

THX in advance!!

Hi Wende
You don't need a macro for this.
Use MailMerge in your word document and use Excel as your source data.
Good luck.
Tony

Thanks a lot Tony!

I’m not familiar with this “MailMerge” function can you briefly describe the steps I need to follow to solve my issue.

Cheers,
Wende

I've managed to use MailMerge disregard the previous message.
THX

Great. Thanks for the feedback.
Tony