Create a file.doc with shopping list from Excel

[Bowser]

Hello, 

I am trying to create a Word file with the shooping list inside from excel worksheet by clicking in the button "Create List" as the following image shows: 

#: the quantity i need of a product for the list
Product: name of a product for the list
The check box (if possible) is for confirmation when i get the product while shopping

The result i wanna get is something like this:

The output of the list for the Word will be depend on the # on the excel, if is blank, isn't include in the list, in this exemple, the Coca-cola

Can anyone help me? i already try a few things, but i am out of my league in code.
Thanks in advance

[#2]

@Bowser 

Use the Mail Merge capability in Word, designating your Excel file as the source data, and whatever criteria needed. No need to "push" it via VBA from Excel when the wizards at Microsoft have already made it quite easy to "pull" the data into Word.

[#3]

Thanks for your reply and time.
It doesn't work as i pretend, because i can only have one variable to get a record at a time form each columm, i can't have multiple variables to get different record at the same time. This works better for actual letters/mail when you only need to change some part of it.

[#4]

@Bowser 

I'm not following your explanation of what doesn't work. Be assured, though, that you can do some fairly sophisticated mail merge routines (IF...THEN... ELSE kinds of conditions) (I did it with Excel and Word over 20 years ago, using multiple conditions in Word)...can't recall now the details.

However, I'm sure you could use Excel to handle those multiple conditions, to create a table to be used as a data source......You just need to play with this a bit.