Generate forms filled with data from file

%3CLINGO-SUB%20id%3D%22lingo-sub-2752761%22%20slang%3D%22en-US%22%3EGenerate%20forms%20filled%20with%20data%20from%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752761%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20enormous%20amounts%20of%20data%20spread%20accross%20(say)%204%20columns%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EName%20Surname%20Age%20City%3C%2FP%3E%3CP%3E1%3C%2FP%3E%3CP%3E2%3C%2FP%3E%3CP%3E3%3C%2FP%3E%3CP%3E.%3C%2FP%3E%3CP%3E.%3C%2FP%3E%3CP%3E.%3C%2FP%3E%3CP%3E1M%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20turn%20every%20single%20row%20into%20a%20form%20of%20the%20following%20kind%20(everything%20is%20dummy%20data%2C%20so%20ignore%20the%20nonsense)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHello%2C%20%5BName%5D.%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EYour%20surname%20is%20%5BSurname%5D%20and%20you%20are%20%5BAge%5D%20years%20old.%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EYour%20hometown%20is%20%5BCity%5D.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20form%20in%20Excel%20that%20will%20be%20able%20to%20automatically%20take%20every%20entry%20in%20my%20table%20and%20turn%20it%20into%20a%20particular%20template%20as%20the%20one%20in%20bold%20above.%20Each%20of%20the%20generated%20forms%20will%20then%20be%20printed%20and%20become%20a%20shipping%20note%20that%20will%20be%20sticked%20to%20various%20boxes%20that%20my%20company%20delivers.%20I%20hope%20this%20makes%20sense.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20how%20to%20do%20this%20(I%20have%20no%20VBA%20knowledge).%20Could%20you%20help%2C%20please%3F%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2752761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2752880%22%20slang%3D%22en-US%22%3ERe%3A%20Generate%20forms%20filled%20with%20data%20from%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752880%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1156641%22%20target%3D%22_blank%22%3E%40ibc12%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20use%20mail%20merge%20in%20Word%2C%20with%20the%20Excel%20data%20as%20source.%3C%2FP%3E%0A%3CP%3ESee%20for%20example%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprint-labels-for-your-mailing-list-276a2cd1-74d2-43d0-ab5a-b90460358ad5%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPrint%20labels%20for%20your%20mailing%20list%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 the following kind (everything is dummy data, so ignore the nonsense):

 

Hello, [Name].

Your surname is [Surname] and you are [Age] years old.

Your hometown is [City]. 

 

I need to create a form in Excel that will be able to automatically take every entry in my table and turn it into a particular template as the one in bold above. Each of the generated forms will then be printed and become a shipping note that will be sticked to various boxes that my company delivers. I hope this makes sense. 

 

I don't know how to do this (I have no VBA knowledge). Could you help, please?

Thank you!

 

2 Replies

@ibc12 

You could use mail merge in Word, with the Excel data as source.

See for example Print labels for your mailing list 

@ibc12 

 

I want to underscore the advice you got from @Hans Vogelaar 

 

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.