Forum Discussion
Generate forms filled with data from file
Hi! I have enormous amounts of data spread accross (say) 4 columns in Excel. For example: Name Surname Age City 1 2 3 . . . 1M I need to turn every single row into a form of ...
I want to underscore the advice you got from HansVogelaar
In fact, he wasn't strong enough, only stating that "you could" use Mail Merge.
I'll say that not only should you use Mail Merge, you should not even think of looking any further for a VBA routine to do this in Excel. You'd just be reinventing the wheel, and not doing anywhere near as good a job.
Microsoft has done that job for us, in Word's Mail Merge, along with Excel as the data source. And it's a marvelously flexible tool, as you'll find if you explore it just a little bit. For the forms you want to create, it will be a breeze, but you'll just be scratching the surface.