Creat Macro in word to talk with Excel 3

[eit09]

Creating a macro in word to fill out report templates. I manually fill information in excel then copy & paste each cell into corresponding advanced properties place holder text already created in word. Is it possible to write a macro to match names from the word properties text and replace with corresponding values from an excel workbook? I have attached a PDF of exactly how my template works now without a macro. If helpful I could upload the word and excel files that I am trying to force to talk with each other. I have tried the record macro, but I can’t get the macro to do what I want. Any suggestions on where to start would be great!

 

[MintJulep]

Sounds like Mail Merge.

 

[zelgar]

MJ is right, a mail merge will easily let you get data from an excel sheet and put them in a word document. This doesn't involve any macro's, and is fairly easy. You'll end up with a document with different fields that will represent data coming from the excel spreadsheet (e.g., Company, Plant, Location, Date, etc.) and you'll be able to merge the data with the data from the spreadsheet very efficiently.

 

[eit09]

Thanks Guys mail merge works perfectly!!