(2/2) Automating Word Documents from Excel - No VBA - Building Forms and Using Formulas

How to fill word documents from Excel. This could be useful for mass mailings or for forms that you need to fill out repeatedly - and you won't have to use VBA. This video covers building a data entry form and using a couple basic formulas.

[JackelineOrtiz]

Thank you Andrew; is a great content; I truly appreciate it. If may I ask a question, how you can apply this formulas to the following rows so you don mis the information or have to start over each time?

[notexactlyrocketscience]

how would you add several names listed in a column. say, add name1 to word, then name2, etc up to 10 names. i cant make word select data from a given row, just a given column. and then it only picks the first entry and there is no option for the other rows? using office 365

[acedelacruz]

Thank you very much for this. Your video is very helpful to me 🥰

[RafTube]

How do you point to a relative path, so if I copy and paste template folders for specific clients (..\client1, \client2), the word will always pull from the right file, and not the absolute path?

[joetrimboli]

How do you add a new record in the table from the form?

[rambopang]

the excel default will take the data in a vertical mode instead of horizontally.

Any way to change that? because I have a massive data that is better to present like a list down instead

[MixFor-rtnl]

Thank's.
Can we use it to modify the word template with the last record we created.
BR

Does someone know how to keep the format from the data in the Excel file? say I wanted the date to be bold and with a blue font color as it would be formated in the corresponding field in the Excel file without having to format it in word?

[asvyoutube]

How do you customise the names of the files created

[saradhahariharan]

Thanks Andrew. Can you tell me how to save the output in different word files. Eg: I have to create 5 template word files. Currently i get 5 pages in same word file. But I want 5 different word file

[jamesashmead]

Can you do this in Outlook rather than Word?

[drknockers]

It was all going so well until the date format got weird XD

[Divine_Bliss_]

how to fetch hyperlink from excel sheet to word...after fetching it should show it as a hyperlink and not just plain text.

[sajithlahiru]

Mr.Andrew, how can i contact you to know more about this?