• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MS Word Letter from dynamic excel range

A

Amit Bhatia

New Member
Hi,

I am very new to vba and I'm trying to create an automated letter system for my organisation where excel has a list of items which varies in numbers. I'm unable to find examples online. I have attached a sample file where the lines are added as per need. It could be any number from 1. The letter needs to have all the information available in the list.

Thanks in Advance,

AB
 

Attachments

  • Sample.xlsm
    20 KB · Views: 5
Amit

Firstly, Welcome to the Chandoo.org Forums

Have you looked at using Mail Merge from Word to draw in the results and place them where you need?
 
Hui,

Thanks for the response. I have seen the thread on Mail merge, but I am unable to use that on the dynamic list.

Regards,

AB
 
Confusing, since mail merge is per definition something dynamic, meant to work on a set of data that is variable in content, not structure.
 
I would be setting up a table or data area to specifically Mail Merge from in Excel, link it to your data as you please
 
You must log in or register to reply here.
Back
Top