VBA Script to import Excel text and numeric values into a desired format in Microsoft Word

Hi everyone,

So I am looking to create a standardized word document with the correct values properly entered. How would I be able to pull values from different cells in an Excel sheet and auto populate it into Microsoft Word?

It would basically be information such as Name, File number, Date, etc and I want it to automatically be put in a letter head format in Word for example.

I know there is a way but I am reaching out to see if any experts on here want to give this a go. Any help would be kindly appreciated!

Thank you

you will want to use mail merge, more than likely. ever used that? when you do, it creates database fields indicated by the symbols "<" and ">", subscripted. then you can merge excel or access data into it. or are you just wanting to make a single doc, with data pulled from a single XL file? to me, it wouldn't make any sense to write code for a one-off task.

Originally Posted by vba_php

you will want to use mail merge, more than likely. ever used that? when you do, it creates database fields indicated by the symbols "<" and ">", subscripted. then you can merge excel or access data into it. or are you just wanting to make a single doc, with data pulled from a single XL file? to me, it wouldn't make any sense to write code for a one-off task.

Originally Posted by AliGW

Mail merge is built into Word. Have a look at this MS support page explaining how it works: https://support.microsoft.com/en-us/...b-0a948fa3d7d3

Thank you both! I don't mail merge is what I'm looking for. I was actually looking into something just like this: https://www.excelforum.com/excel-pro...-filepath.html