MS Word Generate letter for excel with dynamic list

[amitbhatia]

I have a list in excel which may vary from 1 to multiple. I need to create a macro where I can generate a letter in MS word with details of all lines in the letter. The list can be 1 or more than 1 items.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]MRP[/TD]
[TD]Discount[/TD]
[TD]SP[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Macropod]

Simply name the range in Excel, then copy & paste it into Word using Paste Special, with the 'paste link' option and the paste format of your choice. From then on, the Word document will be linked to the Excel range; as you change the Excel data or expand/contract the range, so too the content in the Word document will be updated.