Autofill Macro from EXCEL to WORD

[rs.blackcat]

Hello,

I'm completely new using VBA, macros and programming as a whole. I'm trying to make a macro that replaces some predefined words from a *.doc document with values (in this case words) of a cell from an excel-sheet.

My aim is to have an automation for an excel-sheet with the data as shown below. And a form/application/some ms-word document that needs to be fill out.

FIST_NAME MIDDLE_NAME LAST_NAME D.O.B

The macro will just replace the values entered in the excel-sheet to the *.doc document.

Can someone please help me with this? Thank you.

[Kenneth Hobs]

IF you want to Replace a string then you need a Find string.

'FindReplace Text
' http://www.excelforum.com/excel-prog...-ms-excel.html
' Multiple Find/Replace
' http://www.excelforum.com/excel-prog...o-to-word.html
' Single Find/Replace
' http://www.vbaexpress.com/forum/showthread.php?t=38958

[snb]

I think you should look at the mailmerge method in Word.
You can link the Excel file to the Word file and insert ('replace') the Excel data in the Word document.