Forum Discussion
Create a file.doc with shopping list from Excel
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 o...
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.
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.
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.
